SUMPRODUCT formula not working URGENT

[cafeaulait]

Hi all

The formula =SUMPRODUCT(SUMIF(INDIRECT("'"&"Tabs"&"'!A:A"),$B$348,INDIRECT("'"&"Tabs"&"'!S:S"))) is not working, it returns #REF

Tabs range is defined as =OFFSET('Tab List'!$A$1,0,0,COUNTA('Tab List'!$A:$A),1)

Can I reference entire columns in SUMPRODUCT???

I have to do this really urgently!!!

Kind regards
Genevieve

 

[CharlesChuckieCharles]

SUMPRODUCT doesn't appear to be adding anything sumif is doing all the work here

SUMIF(Lookuprange is Indirect tab column A

Criteria is $B$348 ( a very fixed location)

Sumrange is Indirect tab Column S )

So you're trying to define the sheet name for the indirects from the offset

but you're trying to return a multi cell reference for a sheet name???

 

[cafeaulait]

Thanks, I found that it was the range tabs which I had incorrectly put between quotation marks. It now works!