View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vmagal1
 
Posts: n/a
Default Fill Sum of months by quarter

I have values for Jan - Dec and need to sum them by quarter on another sheet.
When I try to drag the formula across for Q2, Q3, and Q4, it won't grab the
corresponding months, instead it takes the consecutive numbers and sums them.
How can I fix this?