I assume that you want the 75% for store 1 and the 40% for store 2
correct? When you enter the formula, be sure that your range has the $
in front of it as it is shown in both posts. If you do not, your CF
will not apply correctly when copying it to the other cells using the
format painter. If you have more weeks, you have to extend your range
to include those weeks as well.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=515488