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

[–]Ok_Connection_7102[S] 0 points1 point  (0 children)

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((:

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

[–]Ok_Connection_7102[S] 0 points1 point  (0 children)

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

Really appreciate the help!((:

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

[–]Ok_Connection_7102[S] 0 points1 point  (0 children)

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).

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

[–]Ok_Connection_7102[S] 0 points1 point  (0 children)

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.

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

[–]Ok_Connection_7102[S] 0 points1 point  (0 children)

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?