Countif

[Guest]

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]

Hi DG,

Try something like this:

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

Regards,
KL

 

[Guest]

Thanks KL I will try it.

Hi DG,

Try something like this:

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

Regards,
KL

 

[Guest]

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]

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

Regards,
KL

 

[Guest]

Thanks KL! Right again!

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

Regards,
KL

 

[Guest]

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