Forum Discussion
Referencing across sheets using row numbers
Dear All,
Sheet 1 summarises Values listed in Sheet 2.
Sheet 1 has categories listed in Column A , and a formula in Column B
Sheet 2 contains a list of expenses that I want add up in Sheet ...
Have you considered using a pivot table? Very flexible and no formulas required at all.
Dear Jan,
Thank you for your response.
I wasn't aware of pivot tables, I will try it !
Best regards,
Ben
