Count the total # cells with a specific word in a filtered column?

Heather_Goetz_DAL

I have a COUNTIF but it is retruning a value that represents the entire sheet and not just the number of cells on the filtered sheet. Is it possible to restrict the formula to the filtered sheet only?

AKnight

Hey @Heather_Goetz_DAL !

You should try the COUNTIFS function instead. You can add additional statements in countifs that are being used in your filter to restrict the data that is being counted. A formula will always count everything that is present (regardless of filter) so by adding additional IF restrictions, you can get the data you are looking for.

Hope this helps!

Heather_Goetz_DAL

Thanks Ashley by chance do you have an example you can share. I am not sure how to use COUNTIFS. That is a new one for me.

Heather