Sumif across multiple rows / range

[tntra]

Hello !

I've been trying to find a formula to sum as below, unfortunately sumif does not work as there are multiple rows in my spreadsheet that might keep changing, so I'm looking to create a fixed formula that can sum based on a criteria within the given range.

E.g. based on the chart below, I'd like to sum all the quantities below "Apple" within the entire range.
I've tried =sumif(A1:G1,"Apple",A2:G2) but that only works for one row, I'd need to auto formulate for it to replicate this across the whole range.
The rows are not finite, and new rows might be added within the given range.
Would anyone have a suggestion as to how this can be done?
Thank you!

A	B	C	D	E	F	G
1	Apple	Apple	Pear	Grape	Apple	Pear
2	10	30	30	10	20	10
3
4	Apple	Apple	Apple	Pear	Grape	Pear
5	20	20	10	30	30	30
6
7	Apple	Pear	Pear	Grape	Apple	Apple
8	30	30	20	10	10	20

 

[aarti_rto]

you can try "sumifs" for multiple criteria's

 

[StephenCrump]

Welcome to the Forum!

You can use SUMIF:

Book1
	A	B	C	D	E	F
1	Apple	Apple	Pear	Grape	Apple	Pear
2	10	30	30	10	20	10
3
4	Apple	Apple	Apple	Pear	Grape	Pear
5	20	20	10	30	30	30
6
7	Apple	Pear	Pear	Grape	Apple	Apple
8	30	30	20	10	10	20
9
10	SUM	170
Sheet5

Cell Formulas
Range	Formula
B10	B10	=SUMIF(A1:F7,"Apple",A2:F8)

Important caveat: the formula assumes the headers and the values will never match.

 

[tntra]

thank you for your amazing help!!! made my day.