I have a Sales Rep Tracking sheet to track some statistics. I've created a formula to calculate a rating of 1-4 based on hitting certain numbers. Now I want to find the average of their rating but can't seem to get a formula to work on the results of rating formula. I've attached my sample. I need a formula in cell B3 to calculate the average of the results in cells C3:O3 which contain a pretty complex array formula. Can anyone tell me what to put in B3 to get the desired results?
Thanks,
Audrey
Bookmarks