Count Blanks
On Aug 6, 3:04*pm, "Bob Phillips" wrote:
I thought you were saying column A had the value TRUE.
=SUMPRODUCT(--(A2:A20="Paul"),--(B2:B20=""))
--
__________________________________
HTH
Bob
"Paul" wrote in message
...
On Aug 6, 12:36 pm, "Bob Phillips" wrote:
=SUMPRODUCT(--(A2:A20),--(B2:B20=""))
--
__________________________________
HTH
Bob
"Paul" wrote in message
...
I have a long lost os Data in Col A and figures in Col B, I know I can
use a sumif to count figures in ColB if they met criteria in ColB.
But what I need to is count Blank cells in ColB only if they = certain
criteria In ColA, ie if ColA = True then count ColB if the cell is
blank
Thanks,- Hide quoted text -
- Show quoted text -
I am sorry but I have tried this and it will not work,
1 Col-A * Col-B
2 Paul * *1
3 John * 1
4 Paul
5 Paul 2
6 Paul 2
I want the formula to look at all the Pauls and return a value of how
many blank cells are in Col-B (Paul only - row 4)
Thanks- Hide quoted text -
- Show quoted text -
Thank you ever so much. It is working
|