| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=DSUM problems
I have a database set up with accounts that are a lot alike, ie: 9C, 9C-S, or
4.12, 4.12 CO, 4.12 CO/LE, so when I set up the =DSUM it looks at the database and totals everything that begins with 9C or 4.12 and puts them all in one ... I need them separated by account. Any suggestions how to get Excel to separate these accounts? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=DSUM problems
Instead of using 9C in the criteria cell use
="=9C" that will only sum the occurrences of 9C and not include 9C-S, or for 4.12 use ="=4.12" -- Regards, Peo Sjoblom "frustrated!" wrote in message ... I have a database set up with accounts that are a lot alike, ie: 9C, 9C-S, or 4.12, 4.12 CO, 4.12 CO/LE, so when I set up the =DSUM it looks at the database and totals everything that begins with 9C or 4.12 and puts them all in one ... I need them separated by account. Any suggestions how to get Excel to separate these accounts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems using DMAX, DSUM, DAVERAGE with new table | Excel Worksheet Functions | |||
| DSUM Date problems | Excel Discussion (Misc queries) | |||
| Criteria problems in the DSUM function | Excel Worksheet Functions | |||
| Array Formula Limits (around 2800 or so) ? Lotus DSUM has no problems with it ! | Excel Discussion (Misc queries) | |||
| DSum problems | Excel Worksheet Functions | |||
Linear Mode
