Count cells If equal to certain text

[CodyTH]

Hello Everyone,

I was hoping anyone could help me with a formula here.
There is a big table with a lot of data that I am working and I would like to count the value of the cells that have a specific text on another column on the same row.

I did an example table to explain it. picture attached.

Would anyone help with how to count the qty of all values on column C - 'Qty' that contain 'Apple' on column A - 'Fruits'.

Basically, the formula will count cells: C2 + C5 + C8.

Thanks a lot for taking the time and checking it.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=sumifs(c:c,a:a,"Apple")

 

[CodyTH]

Nevermind guys, just thought that i can pivot data. another similar thread reminded me of that.

not my day

 

[JamesCanale]

MrExcelPlayground13.xlsx
	A	B	C	D	E
1	fruits	origin	qty
2	apple	a	30		51
3	pear	b	12
4	banana	c	5
5	apple	d	11
6	pear	e	23
7	orange	f	11
8	apple	g	10
Sheet1

Cell Formulas
Range	Formula
E2	E2	=SUMIFS(Table1[qty],Table1[fruits],"apple")

 

[CodyTH]

Hi & welcome to MrExcel.
How about

=sumifs(c:c,a:a,"Apple")

Thanks a lot Fluff. that works great. just thought about pivot a few minutes ago

 

[Fluff]

Glad we could help & thanks for the feedback.