COUNTIF

Topic

New Reply

I want to use something like COUNTIF, but I need to be able to check 2 non-consecutive columns for specific values. For instance, I need to check a range of cells in column A for the value 20 and column F for the value 10. When both are true, then count it. I am thinking there is a way to use an Array Function along with a “double” COUNTIF. I just can’t figure it out. Any ideas?

Reply | Quote

Replies

Try this:

{=SUM(($A$1:$A$5=20)*($F$1:$F$5=10))}

This is an array formula and must be entered using Control+Shift+Enter

Reply | Quote

Thank you, Thank you, Thank you !!!
I knew it was possible, but I just couldn’t remember how.

Reply | Quote