| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Sum functions with 2 criterias
Question:
Category Processed (Yes) Not Processed(No) Count Sum(Amt) Count Sum(Amt) 1 - 25 26 - 50 51 - 100 101 - 250 Total Data has two columns which are Amount and Status(Yes/No). Can someone help me with the formulae to count the number of coumns which fall in each Category and also sum of the amounts in those categories? -- Sue |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count for multiple text criterias | Excel Worksheet Functions | |||
| Count with multiple criterias | Excel Worksheet Functions | |||
| functions to count Yes & No | Excel Worksheet Functions | |||
| "Count If" 3 criterias are fulfilled | Excel Discussion (Misc queries) | |||
| Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions | |||
Threaded Mode
