Lookup/Match Formula

[Dan R.]

Here's my spreadsheet:

Column B - PRICE (all different), Column C - QUANTITY (some blank)

Then several rows down I'm trying to calculate the total (price x
quantity of each item).

So basically I need it to look in column C and if it finds a number
then multiply that number by the value in column B of the same row. I
tried Lookup but it didnt work since you have to specify the number to
search for.

Any ideas? It must be a COUNTIF, MATCH, INDEX of some kind.

Thanks

 

[Dan R.]

Nevermind, I rememeber... It's sumproduct.

Thanks.