Finding values by using text in other cell

[bigsmile]

Hello,

I am trying to create a cell that show the value of all specified rows with specific name.

For example:

Apples $2 $5 $10
Oranges $5 $10 $50
Apples $5 $ 6 $ 60

(each of these will be in their own cells, 3 rows and 4 columns)

How do I create a cell that will sum the total value of all the Apples by using Apples as the variable?

Thank you.

[martindwilson]

=SUMPRODUCT(($B$1:$D$4)*($A$1:$A$4="Apples"))