I need help. I've create a spreadsheet that includes many towns with subtotals. I figured out how to create a SUMIF statement for a specific town, now I want the average for the for the specific towns.
My IF formula is =SUMIF(E2:E100,"Port Hope",I2:I100)
How do I get the the average for the town?
My IF formula is =SUMIF(E2:E100,"Port Hope",I2:I100)
How do I get the the average for the town?