Lookup/Match Formula
 

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

Lookup/Match Formula
 

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

Thanks.

On Oct 6, 10:42*pm, "Dan R." wrote:
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