View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michel Khennafi Michel Khennafi is offline
external usenet poster
 
Posts: 10
Default Conditional summing

Good morning,

I have a list of transactions in a file.. Each transaction refers to a
weight shipped.

I would like to count the number of shipments between:
- 0 and 1000 Lbs
- 1001 lbs and 1500 Lbs
- and so on

The weight limits are in a table A1: B10... I would like to have the result
by weight rance in cells C1 to C10.
What would be the formula to use in order to do so? I tried countif and
sumif and got no good results...

Thanks