I've attached a sample to view the issue. Here's also a screenshot.
testetestestest.jpg
I'm trying to add cells G6,I6,K6,M6,O6 and then subtract the sum of H6,J6,L6,N6.
The formula would be in E6. The total should be 3.
I've tried the following formula with no luck. I also tried changing the format of the cells from General to Number. I even tried creating two separate columns, one adding the first set, 2nd adding the other cells. But it won't add F6,H6,J6,L6,N6.
I'm thinking there's a circular reference issue going on but I can't seem to track it down.
Each cell contains a formula instead of just a number. Example: G6 has =W206 (Helper columns starting a Q206) instead of 1.
Bookmarks