In the attached model, I don’t understand why the TOTALS do not MATCH (page two/PSE&G). This is highlighted by large black rectangle. I made another copy of the calculation to the right but it does the same thing.
Below this, I entered the numbers manually and they matched (YELLOW).
The data in G35 and G36 as well as the data in J39 and J40 are taken from (copied) a master data base. I do not have any control of the data being copied and entered into these cells.
Thanks In Advance,
INVOICIING DATA.xls (209.5 KB)