Forum Discussion
SUMIF INDIRECT #REF Error
Hi,
I am currently struggling with performing a SUMIF INDIRECT formula as can be seen in the below linked youtube video:
https://www.youtube.com/watch?v=OM4MAaQ4oN0
My aim is to sum the total of each category (Bill/Payment/Journal/Currency Revaluation) using the tab name as a reference in the SUMIF formula (attached excel sheet is a shortened version, this has to be replicated across multiple tabs), however it is returning a #REF error.
Any help you can give will be really appreciated.
Thanks,
Kieran
Kpavey Include single quotes around the sheet names. Needed since these contain a special character.
=INDIRECT("'" & $B$3 & "'!B:B") or change the content of cell B3 to '1293-103'
That should work.
2 Replies
- Riny_van_EekelenPlatinum Contributor
Kpavey Include single quotes around the sheet names. Needed since these contain a special character.
=INDIRECT("'" & $B$3 & "'!B:B") or change the content of cell B3 to '1293-103'
That should work.
- KpaveyCopper ContributorPerfect, that's helped a lot thanks very much!