SUMIF INDIRECT #REF Error

[Kpavey]

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

[#2 · Accepted 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.

[#3]

Perfect, that's helped a lot thanks very much!