SOLVED

SUMIF INDIRECT #REF Error

New Contributor

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.

 

Kpavey_0-1629794482982.png

 

Thanks,

 

Kieran

2 Replies
best response confirmed by Kpavey (New Contributor)
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.

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