MINDFULLYLIZ
New Member
 Joined
 Sep 2, 2020
 Messages
 6
 Office Version

 2016
 Platform

 Windows
Hi! I have been struggling for 5 days trying to get this formula to work. Basically, I need it to search across a few worksheets which I have named "JON" and sum a corresponding cell if it meets two conditions.
The formula returns a "Value" error:
=SUMIFS(INDIRECT("'"&JON&"'!$F$16:$F$65"),INDIRECT("'"&JON&"'!$A$16:$A$65"),$A5,INDIRECT("'"&JON&"'!A1:A1"),$B5))
Please tell me what I'm doing wrong.
Also note on the second criteria I've changed the "A1:A1" to just A1 and A1:A2 and A1:B2 to see if that helps
The formula returns a "Value" error:
=SUMIFS(INDIRECT("'"&JON&"'!$F$16:$F$65"),INDIRECT("'"&JON&"'!$A$16:$A$65"),$A5,INDIRECT("'"&JON&"'!A1:A1"),$B5))
Please tell me what I'm doing wrong.
Also note on the second criteria I've changed the "A1:A1" to just A1 and A1:A2 and A1:B2 to see if that helps