Adding the values of a column after meeting criterion

[Mirell]

I have tried to apply this formula to my spreadsheet but I'm getting a reference error:

=SUMPRODUCT(SUMIF(INDIRECT("'"&A2:A6&"'!A2:A23"),"Feeder",INDIRECT("'"&A2:A6&"'!B4:B23")))

The names of the sheets are referenced in A2:A6 and I am trying to add the values in in B4:B23 across all sheets if any cell in column A meets the criterion "Feeder".

Any help would be much appreciated!

[FDibbins]

Hi, welcome to te forum

I see that this thread is marked SOLVED. Is this correct, did you find an answer, or do you still need assistance?

To save time, upload a sample workbook