How to SUM for indeterminate number of rows?
You could just do:
=SUM(B:B)
as long as the formula is not in column B - it will ignore blanks and
text.
Hope this helps.
Pete
On Feb 20, 1:02*am, MrNobody
wrote:
I have a column of numbers starting at cell B3. The number of rows is not
fixed - it changes. How do I write one SUM function to sum everything from B3
to the last number, whatever row it might be on?
Is there a way to combine it with the COUNT function to accomplish this goal?
Please show me an example
|