Count If with 3 Criteria

aecross

Hi -

Trying to count cells that are 1) Active, 2) have Completed - Not Implemented interiors, and 3) Completed exteriors. I thought count if would be best, but I'm receiving an "Incorrect Argument Set" error. Not sure of the best way to set this up...

=COUNTIFS({TRACKING SHEET Range 11}, "Completed - Not Implemented", {TRACKING SHEET Range 10}, "Completed", {TRACKING SHEET Range 26}, "Active")

Paul Newcome

With that particular error I would suggest double checking your ranges. To reference an entire column in a cross sheet reference, click on the column header.