xor,
Thanks for your help. I modified your formula.
The reason is if I changed the date from 2017 to 2016 I received a "Divide by 0" error.
Code:
AVERAGEIF('Weekly Stats Data '!A15:A45,L6-1,WeeklyStats[SUITABILITY RATE])
''changed to
AVERAGEIF('Weekly Stats Data '!A15:A45,L6,WeeklyStats[SUITABILITY RATE])
To me this appears to work.
Can always depend on help from this forum.
Charles
https://www.excelforum.com/excel-for...-show-n-a.html