Thread: Return a range based on a variable
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Return a range based on a variable
=SUM(A1:INDEX(A1:A5,A7))


"Art" wrote:

Column A contains these five numbers: 9,2,3,5,8
Cell A7 contains the number 4

I need a formula that does the following:
Sum the numbers in column A up to the number of rows in A7.

Formula evaluates to 19 (9+2+3+5)

Thanks,
--
Art
Reply With QuoteReply With Quote