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.