Hi,
Humbly requesting assistance. I am not able to derive the function that I need to count the total number of cases where both conditions are true.
I am trying to count the number cells that meet two conditions.
basically if the value "1" exists in column K, and the corresponding cell in column F also contains the value then count it.
Not sure if this is a COUNTIFS() function or a SUMPRODUCT() function.
Have tried multiple, but no glory as of yet.
Here's what I have: =SUMPRODUCT((K5:K221="1")*(F5:F221="1"))
I'm getting zero with that function. What I expected is that when column K5 is true and column F5 is true the count is incremented by 1. And it would count through row 221.
Thanks in advance!
Tony
Bookmarks