Help with Average across multiple columns

Hey Everyone,

First time poster long time browser.

I'm trying to compile the average with multiple criteria using averageifs. one cell has supervisor's name and then there is 12 columns with different dates. I'm trying to get it to add all numbers that match supervisors name to said column that matches the specified date.

I'm getting a #Value error and can't figure out why and all my googling has ended up with nothing.

=AVERAGEIFS('Combined Data Base'!BK:BV,'Combined Data Base'!B:B,'Supervisor Data'!A3,'Combined Data Base'!BK:BV,'Supervisor Data'!B2)

Any help would be great thank you!

Welcome to the forum.

You can't use a mix of range sizes, but there will be another way.

There are instructions at the top of the page explaining how to attach your sample workbook.

Try this:

=IFERROR(SUMPRODUCT(('sample db'!$B$2:$B$39='sample supervisor'!$A2)*('sample db'!$C$1:$N$1='sample supervisor'!B$1),'sample db'!$C$2:$N$39)/SUMPRODUCT(('sample db'!$B$2:$B$39='sample supervisor'!$A2)*('sample db'!$C$1:$N$1='sample supervisor'!B$1)*('sample db'!$C$2:$N$39<>"")),"")

Which of the three of us are you addressing? John's is the neatest.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of ALL those who helped.

I was speaking about John's, I did mark as solved as well as gave out the reputation for the great help.