E
exceller
Hi All,
I'm new on this forum, so if a solution to this question has been give
already please let me know.
Here's the situation:
In the first row of data a number of reoccurring column labels appea
with a subtotal:
A - B - C - D - Total - A - B - C - D - Total - A - etc... ...- Gran
Total
The sum of the "Total" columns per row is a simple sumif function whic
works fine.
Now I want to count all the non-zero values in the "Total" columns. I
sounds so simple, but I can't figure out a formula to do it..
So the count is based on the label row and an underlying data row wit
each a criterea in the same column.
Is this a VB case and if so, could anyone give me a lead to get on?
I've been trying all kinds of combined formulas with LOOKUPs, OFFSETs
ANDs, IFs, COUNTIFs and what not...
With this count an average would be simple to calculate.
Many thanks!
Excelle
I'm new on this forum, so if a solution to this question has been give
already please let me know.
Here's the situation:
In the first row of data a number of reoccurring column labels appea
with a subtotal:
A - B - C - D - Total - A - B - C - D - Total - A - etc... ...- Gran
Total
The sum of the "Total" columns per row is a simple sumif function whic
works fine.
Now I want to count all the non-zero values in the "Total" columns. I
sounds so simple, but I can't figure out a formula to do it..
So the count is based on the label row and an underlying data row wit
each a criterea in the same column.
Is this a VB case and if so, could anyone give me a lead to get on?
I've been trying all kinds of combined formulas with LOOKUPs, OFFSETs
ANDs, IFs, COUNTIFs and what not...
With this count an average would be simple to calculate.
Many thanks!
Excelle