Sorry about the subject, not sure what else to call it.
I have a formula that works great for what I want to do, except I need it gives a #DIV/0! if there is no data. This is causing a problem because it's not averaging the scores over the months/quarters due to the #DIV/0!.
Is there a way around this on either end?
The formula I'm using is:
=AVERAGE(IF(ScoreData!$F$2:$F$1500=$A3,IF(ScoreData!$B$2:$B$1500=F$1,IF(ScoreData!$H$2:$H$1500,ScoreData!$H$2:$H$1500))))
where: A3=Team Member's Name
F1 = Month
Of course, if there is an easier way to do this or more information is needed, please let me know.
Thanks for all the help =)
I have a formula that works great for what I want to do, except I need it gives a #DIV/0! if there is no data. This is causing a problem because it's not averaging the scores over the months/quarters due to the #DIV/0!.
Is there a way around this on either end?
The formula I'm using is:
=AVERAGE(IF(ScoreData!$F$2:$F$1500=$A3,IF(ScoreData!$B$2:$B$1500=F$1,IF(ScoreData!$H$2:$H$1500,ScoreData!$H$2:$H$1500))))
where: A3=Team Member's Name
F1 = Month
Of course, if there is an easier way to do this or more information is needed, please let me know.
Thanks for all the help =)