View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Oman Oman is offline
external usenet poster
 
Posts: 2
Default Subtotaling Quarters (and Years) from Months

Thanks Bernie - my table isn't a pivot table.

One way around it is to add the quarters at the end of each set of 3
months, so:-

A1=Jan08, A2=Feb08, A3=Mar08, A4=Q1 and so on

but the trouble with this is that the formulae that feed the row data
for the months then also need to be amended for the quarter columns.

Oman