Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
=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. |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |