Count Blanks

[Paul]

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,

 

[Bob Phillips]

=SUMPRODUCT(--(A2:A20),--(B2:B20=""))

 

[Paul]

=SUMPRODUCT(--(A2:A20),--(B2:B20=""))

--
__________________________________
HTH

Bob








- 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

 

[Bob Phillips]

I thought you were saying column A had the value TRUE.

=SUMPRODUCT(--(A2:A20="Paul"),--(B2:B20=""))


--
__________________________________
HTH

Bob

=SUMPRODUCT(--(A2:A20),--(B2:B20=""))

--
__________________________________
HTH

Bob








- 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

 

[Paul]

I thought you were saying column A had the value TRUE.

=SUMPRODUCT(--(A2:A20="Paul"),--(B2:B20=""))

--
__________________________________
HTH

Bob





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