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???
Bookmarks