Excel Formula

Can anyone tell me how to make the follwing formula sum "Apples" and "Pears"?

=SUMPRODUCT((Cost!$D$3:$D$126="Apples")*Cost!$P$3:$AG$126)

It would be much appreciated!

A
Ahmed KHR 👤 Member for 15 years 7 months

SUMPRODUCT((Cost!$D$3:$D$126="Apples")*Cost!$P$3:$AG$126)+SUMPRODUCT((Cost!$D$3:$D$126="Pears")*Cost!$P$3:$AG$126)

Forum Sponsor

Top Posters

Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 posts
Vahidazimi01
0 posts
David Smith
4 posts
Peter Holroyd
51 posts
fridau
0 posts
Rahmat Hidayat
32 posts