| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: Using DSUM, I need to evaluate 2 criteria that are not toge
The CRITERIA field in DSUM looks for adjacent columns in a table. If a column
or cell is blank, it does nothing. How can I use A1:A2 and, say, C1:C2 as the criteria? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: Using DSUM, I need to evaluate 2 criteria that are not toge
Not possible, the criteria range needs adjacent cells, is there any
particular problem involved by not using it this way? -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Know enough to get myself in too deep" <Know enough to get myself in too wrote in message ... The CRITERIA field in DSUM looks for adjacent columns in a table. If a column or cell is blank, it does nothing. How can I use A1:A2 and, say, C1:C2 as the criteria? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| Disjoint range for DSUM criteria | Excel Worksheet Functions | |||
| conditional criteria in DSUM | Excel Discussion (Misc queries) | |||
| how do I isolate only one row in the criteria for the dsum functi. | Excel Worksheet Functions | |||
| DSUM and DCount when criteria values are similar | Excel Worksheet Functions | |||
Linear Mode
