SUMIF Limitations. Lengthy process totalling multiple tables. Seeking other methods.

[dion.m.blake]

Hi,

I'm attempting to return a single value from multiple tables using the SUMIF formula, but am finding it a lengthy process and a lengthy formula if referencing up 1000 tables. (Please see attached file)

=SUMIF(D2:D4,"Apples",E2:E4)+SUMIF(G2:G4,"Apples",H2:H4)+SUMIF(J2:J4,"Apples",K2:K4)+SUMIF(M2:M4,"Apples",N2:N4)+SUMIF(P2:P4,"Apples",Q2:Q4)

This is the formula I'm currently using and am looking to achieve a simple total.

Is there another formula that could be used to achieve the same result in the event that I need to increase the amount of tables referenced?

Any assistance will be greatly appreciated.

[Bo_Ry]

PLease try
=SUMIF($D$2:$P$4,A2,$E$2:$Q$4)
or
=SUMIFS($E$2:$Q$4,$D$2:$P$4,A2)

[dion.m.blake]

PLease try
=SUMIF($D$2:$P$4,A2,$E$2:$Q$4)
or
=SUMIFS($E$2:$Q$4,$D$2:$P$4,A2)

Hi Bo_Ray,

They both worked. Saved me a lot of time. Thanks a lot.