update cell in other worksheet based...
 

I have a worksheet that I use for a weekly summary. The other
worksheets contain a breakdown of what was done.

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 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.


--
mwrfsu
------------------------------------------------------------------------
mwrfsu's Profile: http://www.excelforum.com/member.php...o&userid=26459
View this thread: http://www.excelforum.com/showthread...hreadid=397275