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 6 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

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts