Countif with conditions

M

Mosqui

Again, thanks in advance to all the helpers here.

I need to count non-blanks cells in column B depending on the content of the
columnA.

A B
50-01 12/12/05
50-01
30-02
 
B

Biff

Hi!

You didn't say what the dependent condition was.

Use this as a guide and fill in what the logical test is:

=SUMPRODUCT(--(A1:A10...some_logical_test),--(B1:B10<>""))

Biff
 
M

Mosqui

Thanks Biff, works perfect.


Biff said:
Hi!

You didn't say what the dependent condition was.

Use this as a guide and fill in what the logical test is:

=SUMPRODUCT(--(A1:A10...some_logical_test),--(B1:B10<>""))

Biff
Click to expand...
 
Top