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
|