Thanks KL I will try it.

"KL" wrote:

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.