Sum across muiltiple sheets only when crieria met

[Phil Payne]

Hello all,

I've tried if, sumif, sumproduct, indirect etc and cannot find a way to do this i hope someone can help me.

My Summary sheet contains a cell with the following formula =SUM(Abe:Wyn!I7) (where Abe:Wyn = 218 worksheets and identically formatted)

This has worked well but now I need to ignore certain of the sheets between Abe and Wyn and cannot remove or reorder them.

My chosen way of doing this was to look for the contents of a particular cell on my Summary sheet in the same cell on each of the 218 sheets and if found sum values of other cells (I7) to total.

I want to =SUM(Abe:Wyn!I7) but only if Abe:Wyn cells C7 equals C7 on my summary sheet.

Can anyone help please?

Thanks

 

[Phil Payne]

Hello XOR,

Brilliant. Thanks

Very glad you mentioned the 'orthogonal' rule as it didn't work at first.

All the best.

 

[XOR LX]

No worries!

Cheers