I am looking to use averageif for multiple ranges:
=AVERAGEIF((A120:B124,A182:B186,A244:B248,A306:B310,A368:B372,A430:B434,A492:B496,A554:B558,A616:B620,A678:B682), "Individual Training", (K120:K124,K182:K186,K244:K248,K306:K310,K368:K372,K430:K434,K492:K496,K554:K558,K616:K620,K678:K682))
but I keep getting #VALUE! returned.
Am I inputting incorrectly, or is there another way to do this?
Thanks
Bookmarks