I am having trouble summing across multiple worksheets.
I have a "Totaliser" sheet which has the relivant search info on it.
eg Cells F5:F100 hold the Criteria for the SUMIF.
on the following sheets is the data which needs to be sumed if that criteria
is met.
The value then goes in the cell range D5:D100 on the Totaliser sheet.
I have to collate about 80 sheets and the data matching might not be on the
same lines within those sheets but the info is in the same coloums.
This is the formula i have tried to use (on 2 sheets to start)
=SUMIF('065Aldis:065test2'!G3:U100,Totaliser!F5,'0 65Aldis:065test2'!G3:U100)
this appears to only work on one sheet.

The data required is simply counting the qtys of all codes that are the same.

What am I doing wrong?