View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MrNobody MrNobody is offline
external usenet poster
 
Posts: 4
Default How to SUM for indeterminate number of rows?

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