Hi

One way
=SUMIF(A:A,"<500",C:C)

--
Regards

Roger Govier


"b1888" wrote in message
oups.com...
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