View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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