Hi,
I have 12 sheets Jan-Dec. In another sheet, sheet1 I want to sum C6:Z6 in all the sheets if the month is over.
In sheet1 I have January as text in B3 and a formula in B4 that returns the previous month from today, September
I am using =SUM(January:December!C6: Z6) to get the total of all sheet, but how do I get January to Septembers total
Any help greatly appreciated
Kevin
Bookmarks