hi, im new to excel and i need help if possible
i have 3 sheets: sheet1, sheet2, sheet3
i want from sheet1 to sum B3:b4
then to substract the result form sheet2 b3:b4
and the result to be displayd in sheet3
i tried =SUM(sheet1!B3:B4)&""&=sheet1!B3-sheet2!B4
and it doesnt work
cant seem to combine them together
i have 3 sheets: sheet1, sheet2, sheet3
i want from sheet1 to sum B3:b4
then to substract the result form sheet2 b3:b4
and the result to be displayd in sheet3
i tried =SUM(sheet1!B3:B4)&""&=sheet1!B3-sheet2!B4
and it doesnt work
cant seem to combine them together