View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jdunnisher jdunnisher is offline
external usenet poster
 
Posts: 8
Default Sum below a specific row

I am attempting to use the SUM function to add values below a certain row? I
know that SUM(A:A) can be used to add every value in the column, and
SUM(A1:A5) can be used to add values in a defined range.

What do I do if I only know one of the values in my range? For example, I'd
like to be able to add the values in column A for every row below row 8
without having to change the defined range each time. e.g - SUM(A9:A??)

How can this be accomplished?