Forum Discussion
Solved
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 tota...
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.
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!
