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,

=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,

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

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

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