Count "Criteria" in a Filtered List

Hi everyone,

I have, in excel, a dataset of project activities (about 5,500 activities) where one of the columns are labeled "Critical Activity" and then in each row corresponding to the unique activity a simple "Yes" or "No" status is displayed.

I have linked the data to an advanced filter, and as I filter I would like to count the number of critical activities in the filtered group.

Does anyone have any suggestions on how to do this?

Basically what I want is =COUNTIF("criteria range", "Yes") but with the ability to ignore invisible rows in the filtered list.

Thank you in advance - hope the question was clear!

Cheers!

Try something like this...

Assume the range is A5:A100.

=SUMPRODUCT(SUBTOTAL(3,OFFSET(A5,ROW(A5:A100)-ROW(A5),0)),--(A5:A100="Yes"))

You may need to replace the commas with semi-colons.

You're welcome. Thanks for the feedback!