Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match or Lookup formula help please | Excel Worksheet Functions | |||
Lookup & Match formula | Excel Worksheet Functions | |||
If & Lookup & match Formula Required! | Excel Discussion (Misc queries) | |||
Lookup/match formula? | Excel Discussion (Misc queries) | |||
Excel Lookup MATCH formula | Excel Discussion (Misc queries) |