I assume you have 'cost of product' in column B and your 'sell price' in
column C, starting in row 1 and ending in row 17000.

Compute the profit margin in column D (column C - Column B) the value you
wish to sum..
Then use the SUMIF command using the range in column C, a criteria of
"<=1000" for lower price and "1000" for the higher price, summing column D

The formula are

=SUMIF(C1:C17000,"<=1000",D1:D17000)
=SUMIF(C1:C17000,"1000",D1:D17000)

Cheers
Nigel


"dance-evil " wrote in message
...
hi there,

I would like to know what's the easy method for working out profit
margin especially for 17,000 products with variation price

all the variation price is at the column C:

but it would be nice to add variation profit margin for each price eg.

lower price (1.00 to 1000) = higher profit margin
higher price = (1001 to 60,000) lower profit margin

thank for ur help


---
Message posted from http://www.ExcelForum.com/