Countif

DG · Jun 29, 2005

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.

KL · Jun 29, 2005

Hi DG,

Try something like this:

=SUMPRODUCT((A1:A100="")*(B1:B100<>""))

Regards,
KL

DG · Jun 29, 2005

Thanks KL I will try it.

KL said:
Hi DG,

Try something like this:

=SUMPRODUCT((A1:A100="")*(B1:B100<>""))

Regards,
KL

DG · Jun 29, 2005

Okay perfect, that gave me the count. Is there a way to sum the numbers that
it represents as well? I know that I have 1000 new entries, but those
entries could be anywhere from 10 to 1000, how do I calculate the total?

KL · Jun 29, 2005

=SUMPRODUCT((A1:A100="")*(B1:B100<>"")*B1:B100)

Regards,
KL

DG · Jun 30, 2005

Thanks KL! Right again!

KL said:
=SUMPRODUCT((A1:A100="")*(B1:B100<>"")*B1:B100)

Regards,
KL

DG · Jun 30, 2005

I spoke to soon, I am getting the #Value error. Any other suggestions??