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
|