Sum Multiple Columns With One Criteria

[Lewzerrrr]

Hi,

How can I sum up each column based on the criteria inputted? What I've used is this but obviously not the most practical.

=SUMIF(B2:B25,K2,C2:C25)+SUMIF(D2:D25,K2,E2:E25)+SUMIF(F2:F25,K2,G2:G25)+SUMIF(H2:H25,K2,I2:I25)

How can I simplify this?

Oranges	39	Pears	76	Pears	10	Oranges	62		Oranges	1,862
Pears	48	Apples	49	Oranges	78	Pears	93
Pears	50	Apples	42	Pears	50	Pears	26
Oranges	60	Oranges	81	Oranges	17	Apples	77
Apples	53	Oranges	75	Oranges	13	Oranges	52
Pears	75	Pears	78	Apples	8	Apples	13
Pears	3	Apples	47	Oranges	98	Oranges	9
Oranges	62	Apples	33	Oranges	14	Oranges	20
Oranges	65	Pears	49	Oranges	42	Oranges	51
Oranges	30	Oranges	35	Oranges	3	Pears	26
Oranges	67	Pears	40	Oranges	40	Apples	50
Oranges	52	Apples	1	Apples	77	Oranges	82
Oranges	94	Oranges	42	Apples	25	Pears	15
Pears	58	Pears	50	Apples	89	Oranges	8
Apples	11	Apples	65	Pears	95	Pears	86
Pears	33	Pears	81	Oranges	3	Oranges	22
Apples	26	Pears	52	Apples	38	Apples	88
Apples	53	Oranges	7	Apples	60	Pears	80
Oranges	91	Pears	3	Pears	2	Pears	71
Apples	14	Oranges	64	Pears	20	Apples	35
Apples	99	Pears	92	Oranges	48	Oranges	2
Oranges	88	Apples	43	Oranges	95	Pears	9
Pears	25	Apples	16	Oranges	89	Pears	32
Oranges	62	Pears	27	Pears	25	Pears	84

<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Weazel]

maybe something like...

=SUMIF(A2:G25,J2,B2:G25)

 

[steve the fish]

Theres nothing really wrong with what you have but with that data you could do:

=SUMIF(B2:H25,K2,C2:I25)

 

[Lewzerrrr]

Oh cool! Never knew you could do sumif's outside a singular row/column. Learn something new!