text function?
Nine - just as you listed. It will have 60 when complete (Sep-06 to Aug-11).
"muddan madhu" wrote:
how many sheets you have between Sep-09 to Jan-09
is it Sep-09,Aug-09,Jul-09,Jun-09,May-09,Apr-09,Mar-09,Feb-09,Jan-09
On Oct 23, 8:14 pm, SixBowls
wrote:
I have the following formula that totals data for multiple tabs. Each tab is
a month and each tab is set-up the same.
=SUM('Sep-09:Jan-09'!C9,'Sep-09:Jan-09'!E9,'Sep-09:Jan-09'!G9,'Sep-09:Jan-09'!I9,'Sep-09:Jan-09'!K9,'Sep-09:Jan-09'!M9,'Sep-09:Jan-09'!Q9,'Sep-09:Jan-09'!S9,'Sep-09:Jan-09'!U9)
The formula works but I have 196 rows where the formula is used. I
currently do a find/replace when I add a new month or want to look at a
quarter. I would like the formula to reference two cells (b3 for what is now
Sep-09 and b4 for what is now Jan-09) and be able to type the sheet name in
those cells to get the period.
Also open to suggestions on a better formula.
.
|