Forum Discussion
Cell Use from one sheet to Another
Hello. I have a multi-page workbook that requires using cells from one sheet on other sheets in the same workbook. I have one instance that in trying to work it out, has caused a second issue. Wh...
HelloScottIGH2025,
If =Wages!G15 returns 0 then G15 on the Wages sheet is evaluating to 0. The issue is on the source sheet not the destination sheet. Confirm that G15 still contains a SUM formula and was not overwritten. Make sure the cells being totaled are numeric and not stored as text. Verify Calculation Options is set to Automatic. You can also test with =ISNUMBER(Wages!G15). If G15 evaluates correctly on the Wages sheet then =Wages!G15 will work on any other sheet.