Forum Discussion
Cell reference adds another cell to its own value?
I'm using a VLOOKUP formula layered with other things to pull values from the Annual Detail sheet into the Invoice to Print sheet. For some reason, cell C15 on the Invoice displays the value it shoul...
justice-landes You provide a lot of information, but left out one important part. What is in the 6th column on the row headed with "YTD Spent"? The formula returns 24 as per the third screen-shot in C3, where you only show two amounts spent for July and August (4+10) for 14. So, either the formula summing the total spend is wrong or the sum range contains a one or more numbers adding up to 10 that shouldn't be there. Perhaps in hidden rows. Can you show a more complete picture of the sheet in the 2nd screen-shot. One that shows the YTD Spent row and the formula in column F on that row?