Updating 1 worksheet with result from another worksheet
 

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.


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