I'm using average IF the name located in B1 matches on Sheet 1 Row K
Then the scores to average are on Sheet 1 Row P
I get that to work just fine with
=IF(D6=0,"",AVERAGEIF(`Sheet 1`!K:K,B1,`Sheet 1`!P:P))
However, now I need to tell it to also only give me the results if it is between 2 dates located on H1 & J1.
B1 is a name that can change
H1 & J1 is a date that can change (start date, end date)
D6 is a number that pulls from Sheet 1. It looks for the name in B1 and counts the times it shows up.
Sheet 1 has all the data
Sheet 1 Row K is where the names are located
Sheet 1 Row P is where the scores are located
Bookmarks