Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula - help needed!
Hi,
My spreadsheet contains 3 columns. A - product code (numerical 1 - 10000) B - product description C - price I need a formula to achieve the following... - any product codes (A) between eg 1-499 i want to add the amount (C) for each of the products in this range. In other words I want the formula to lookup column A, and any number found here that's between 1 - 499 add the corresponding value in column C. Hope that makes sense. Any suggestion greatly appreciated. Cheers, B1888 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions | |||
Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Excel formula needed to amounts into one column pulling from 2 col | Excel Worksheet Functions |