OK, I created an Energy Balace Chart to help me eat healthier and track
my daily progress. Everything works as designed except for my Grand
Total column which I want to calculate once every 7 days. This is a
sample of the formula I used
=IF(Q25=),"".(T18+Q25))

When I open the spread sheet I get this message...Cannot calculate a
formula.Cell reference in the formula refer to the formula's result
creating a circular reference.

Can someone please help??? :)


--
bluenoser1946
------------------------------------------------------------------------
bluenoser1946's Profile: http://www.excelforum.com/member.php...o&userid=26006
View this thread: http://www.excelforum.com/showthread...hreadid=468685