Countif
 

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.

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.

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.

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?

"DG" wrote:

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.

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

Regards,
KL

"DG" wrote in message
...
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?

"DG" wrote:

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.

Thanks KL! Right again!


"KL" wrote:

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

Regards,
KL

"DG" wrote in message
...
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?

"DG" wrote:

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.

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

"KL" wrote:

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

Regards,
KL

"DG" wrote in message
...
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?

"DG" wrote:

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.