LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Summing... AC [MVP MCMS] Excel Worksheet Functions 2 March 11th 06 07:47 PM
Conditional summing Brad Excel Discussion (Misc queries) 1 August 31st 05 10:55 PM
Conditional Summing MartinShort Excel Discussion (Misc queries) 4 July 1st 05 12:11 PM
"Conditional" summing Aladin Akyurek Excel Worksheet Functions 0 January 16th 05 07:46 PM
conditional Summing ben Excel Worksheet Functions 2 January 10th 05 06:51 PM


All times are GMT +1. The time now is 07:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"