I have a worksheet that I use for a weekly summary. The other worksheets contain a breakdown of what was done. All worksheets are located in the same workbook.
I would like to add a formula to the breakdown worksheets that will update the summary worksheet based on a result.
For example, if the result is greater than 95% I want to update the cell in the summary worksheet that goes with 95%. Everytime a result meets this criteria I want to update the summary worksheet cell by 1.
Summary worksheet
0-5% 5-10% 10-25% 25-50% 50%+
Breakdown sheets
Accuracy
95 <- update 0-5% by 1
98 <- update 0-5% by 1
50 <- update 50+% by 1
25
100
Any help would be appreciated.
Bookmarks