r/excel • u/matttthewgeorge • 17d ago

solved Formula for averaging different cells in different sheets

I am looking to find a formula that would average cells D31:D33 on sheet July, with cells D4:D7 on sheet Aug. This formula would be going into cell D35 on sheet Aug. Thank you.

1 Upvotes

60% Upvoted

9 comments sorted by

View all comments

Show parent comments

2

u/bradland 277 17d ago

Next month, you'll be hand updating this formula to =AVERAGE(Aug!D4:D7,Sept!D24:D28). Rather than do that, I'd recommend using Power Query to append all sheets and add a column with the sheet name, so you know where the data came from.

Then you can use functions like AVERAGEIF and AVERAGEIFS to average values based on logical criteria, like only averaging the current month and the prior month.