Conditional counting

A

ArthurN

Hi,
sumif(range,criteria,sum_range) is a very nice function. Is there any way I
can achieve similar result with some count function, something like
countblank(range, on_condition, countblank_range)?
ArthurN

PS countif seems a bit limiting, or is it not?
 
B

bigwheel

Give us an idea of what you want to do. It may well be that a UDF could be
made to do it.
 
A

ArthurN

I wouldn't like to work with the numbers. I would like to find the number of
blank cells, say in column B, where the corresponding cell (row) in column A
wouldn't be empty:
A B
01/13 56
01/14
01/15 43
I can't use countblank(range) because I don't know the range, I know it
starts at b2, I don't yet know where it ends
 
D

Dave Peterson

=SUMPRODUCT(--(A2:A65536<>""),--(B2:B65536=""))

But I think I would be more conservative and just use a row that I know won't be
exceeded.

If you expect 2000 entries, then make it 4000.
 
Top