Hi DG,
Try something like this:
=SUMPRODUCT((A1:A100="")*(B1:B100<""))
Regards,
KL
"DG" wrote in message
...
Is there a way to select a range and count the number of cells that have a
number, but the column before di not have a number? In other words I am
doing a waterfall chart and I need to count the number of new additions in
each cloumn.
|