SumIf or Vlookup on multiple sheets at once

[Dubbelito]

Hi all,
is there a possibility to do a SumIf formula that goes through different sheets in one function when it sums up information?

I have 11 sheets with varying part numbers on different rows (columns are static though) and I want to sum together the quantities on one sheet, how can I do that the easiest way?

The way I see it is that at the moment I need to do "sumif" once for every sheet, which would give me 11 sumif-formulas, and there must be an easier way to do it...

Grateful for any help in the matter!

Best regards,

[arthurbr]

Hi,
is there any relationship between the cells which need to be considered?

[sweep]

Hi,

This can almost certainly be done using a combination of SUMPRODUCT and INDIRECT. Can you post the data (or an example) to work with?