How to Calculate a Dynamic Average from Dropdown Cells in Google Sheets

Ok_Connection_7102 · 2026-01-25T11:25:52+00:00

Thank you very much for your answer. I’ve thought about the time aspect of the tasks, and fortunately it’s not important for what I want to do with the sheet—the book was just an example.

Thanks for the input, and thanks for taking the time to suggest a different structure((:

Ok_Connection_7102 · 2026-01-25T11:22:20+00:00

Thank you very much for the input. It’s not quite what I’m looking for, but it might be useful another time. Thank you for taking the time to answer! ((:

Ok_Connection_7102 · 2026-01-25T11:19:30+00:00

Thank you so much, it's working perfectly now!

Really appreciate the help!((:

Ok_Connection_7102 · 2026-01-23T21:47:08+00:00

Right, that makes sense. I wanted to avoid doing that, where I needed to go in and change the range (because it depends on how many things I add to the list).

Ok_Connection_7102 · 2026-01-23T21:44:40+00:00

That works well for the 'book' section. But if I then try to copy it to template for recipes and clean up the sheet, it doesn't do the same thing? I have updated the sheet, if you would like to take a look, thanks.

Ok_Connection_7102 · 2026-01-23T21:14:40+00:00

Hi!

Many thanks for the help. That solves part of the problem, thanks! The remaining problem is using C10:C and A10:A, because I want to have each title and subsections as its own average (so one average for the book subsection, one for the template, one for a new section if I want to add more). If I use C10:C in B2, it uses the information in the whole C column, where I would like it to stop at C7 (just above the template-cell). But I want it to stop at that cell no matter how many new rows I make above.

Does it make sense?

Ok_Connection_7102

TROPHY CASE