Aug 24 2021 01:42 AM - edited Aug 24 2021 01:44 AM
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
Aug 24 2021 02:12 AM
Solution@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.
Aug 24 2021 02:12 AM
Solution@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.