| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting SumIf and CountIf
I want to count and sum data in one column based on on criteria from two
separate columns. I've tried AND and some othe ways, but can't get it right. Essestially, (in english) count/sum the sales price if the sale type equals a foreclosure and the unit type equals single family home. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting SumIf and CountIf
Art wrote:
I want to count and sum data in one column based on on criteria from two separate columns. I've tried AND and some othe ways, but can't get it right. Essestially, (in english) count/sum the sales price if the sale type equals a foreclosure and the unit type equals single family home. Thanks in advance! http://www.contextures.com/xlFunctio...tml#SumProduct |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting SumIf and CountIf
Thanks! is there an equivalent for count or would I just sumproduct a field
of "1" thanks again! "Glenn" wrote: Art wrote: I want to count and sum data in one column based on on criteria from two separate columns. I've tried AND and some othe ways, but can't get it right. Essestially, (in english) count/sum the sales price if the sale type equals a foreclosure and the unit type equals single family home. Thanks in advance! http://www.contextures.com/xlFunctio...tml#SumProduct |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting SumIf and CountIf
Use the same SUMPRODUCT formula, but don't include the column to SUM.
Art wrote: Thanks! is there an equivalent for count or would I just sumproduct a field of "1" thanks again! "Glenn" wrote: Art wrote: I want to count and sum data in one column based on on criteria from two separate columns. I've tried AND and some othe ways, but can't get it right. Essestially, (in english) count/sum the sales price if the sale type equals a foreclosure and the unit type equals single family home. Thanks in advance! http://www.contextures.com/xlFunctio...tml#SumProduct |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF nesting ??? | Excel Worksheet Functions | |||
| Nesting COUNTIF | Excel Discussion (Misc queries) | |||
| If and CountIF Nesting | Excel Worksheet Functions | |||
| Nesting SUMIF | Excel Discussion (Misc queries) | |||
| nesting with countif | Excel Discussion (Misc queries) | |||
Hybrid Mode
