IF calc auto filter query

[chocolateleaky1]

Hi

Please can someone help with a solution to filtering a column and the IF calculation.


I have used the IF calculation on the word yes in a column. I now need to put a filter on the column and want to be able to count the yes's in the filtered information, but the IF calculation only shows yes's for the unfiltered information.


Is there any way around this?

Regards Clare

 

[Luke M]

This looks pretty similar to your other question:

http://chandoo.org/forums/topic/how-to-calculate-a-percentage-on-filtered-information


Are you wanting to know the number of "yes"'s that are still visible, or count the ones that are hidden?

 

[chocolateleaky1]

Yes, it is the number of visible "yes"s.

 

[Luke M]

Assuming you still have a helper column like before then the formula to count the yes's is just:

=SUMPRODUCT((A2:A100="yes")*(Z2:Z100))

 

[chocolateleaky1]

Brilliant, thank you again Luke

Clare

 

[Luke M]

No problem, thanks for the feedback. Come back anytime!