Sum a value of V Lookups

[rlapi051]

Here is my table

TTE 9
TTE 9
DAP 4
QB 5
ME 7
TTE 9

How do I sum the value of all the "TTE" with a sum product?

My value of "TTE" should be 18.

Thanks,

Ryan

[alansidman]

=sumif(A1:A6,"=TTE",C1:C6)

Assuming your data shown is in A1 through C6

Edit: 3 x 9 = 27