View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fran McConville Fran McConville is offline
external usenet poster
 
Posts: 2
Default summing first 'n' values in a column or row

I'd simply like to sum the first n values in a column or row, where the value
of n is in a separate cell. ie if I enter '3', it will sum only the first
three values in the range, if I enter '8' it will return the sum of the first
8 values in the range. TIA for any help