View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mujeeb ur Rehman, FBL-GRW-PK Mujeeb ur Rehman, FBL-GRW-PK is offline
external usenet poster
 
Posts: 20
Default Partial / Conditional Sum of a Column

There are 12 figures in a column (A1:A12). B1 is a parameter Cell. when I
enter 3 in the parameter cell (B1), result must be {sum(A1:A3), sum(A4:A6),
sum (A
7:A9), sum(a10:a11)}. I Mean to say sum function must be handled with the
paramenter cell (B1), and result will be in other column with parameter
interval i.e., value of (B1) i.e., 3 or 6 or 9 or 1 etc.