Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM using alpha numeric codes
using Excel 2007, I am having difficulty trying to dsum values where the
criteria is for greater than one alpha numeric code and less than another alpha numeric code. e.g sum for items greater than or equal to nadaa00-N1 and less than or equal to nadab00-N0 - items to be included are shown with an * ) nadab00-N0 100 * nadab00-N1 20 nadaa01-N1 10 * nadaa00-N0 40 nadaa00-N1 25 * |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM using alpha numeric codes
please ignore - I sorted it
"brian" wrote: using Excel 2007, I am having difficulty trying to dsum values where the criteria is for greater than one alpha numeric code and less than another alpha numeric code. e.g sum for items greater than or equal to nadaa00-N1 and less than or equal to nadab00-N0 - items to be included are shown with an * ) nadab00-N0 100 * nadab00-N1 20 nadaa01-N1 10 * nadaa00-N0 40 nadaa00-N1 25 * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alphanumeric Sorting - numeric alpha numeric | Excel Worksheet Functions | |||
Alpha Numeric tab not showing only numeric. | Excel Worksheet Functions | |||
only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
How can I find the alpha numeric codes in excel please,Thank you. | Excel Discussion (Misc queries) | |||
The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) |