Next Worksheet Formula

[Papi]

We are using the following formula in Column AL from Row 3 Downward

=SUMIF(May!E:E,E4,May!AL:AL)+AK4

At the end of each month we copy our volunteer hour rows over to the next worksheet directly to the right i.e The data from the month of May will get copied into the June worksheet. As noted above the formula shows May (last month) in the formula. Is there another way to write the formula so that each new month the last month formula will change without having to change the formula using the previous Tab Name (i.e. Jan Feb Mar Apr May etc.)?

The rows are not typically the same size as we retain past volunteer information and seem to be adding new volunteers on a fairly regular basis.

Any help would be greatly appreciated.

 

[CharlesChuckieCharles]

Try using INDIRECT

=SUMIF(INDIRECT($I$2 & "!" & "E:E"),$E$4,INDIRECT($I$2 & "!" & "AL:AL"))+AK4

where $I$2 is your Month Name

(I2 could be a list of month names as in a drop down referenced from somewhere else)

 

[Papi]

Thanks for the very quick response. Your formula works quite well. I will pull out the books to study up on the INDIRECT function as that one is new to me. Thank you very much for all your help!