Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW TO USE DSUM WITH MORE THAN ONE CRITERIA
IM TRYING TO GET THE SUM FROM COLUMN A "SALES " WHICH INCLUDE THE SALES
VALUE BY USING DSUM BASED ON SPECIFIC NAME FROM COLUMN B "NAMES " AND WITHIN SPECIFIC DATE FORM COLUMN C"DATES" ALSO BASED ON SPECIE COUNTRY FROM COLUMN D" COUNTRIES" HOW I CAN SET THE FORM APPRECIATE YOUR HELP MICHAEL |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW TO USE DSUM WITH MORE THAN ONE CRITERIA
Just create two criteria in adjacent columns and use both in the criteria,
such as M1:N2 -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Michael H.M.Mikhail" wrote in message ... IM TRYING TO GET THE SUM FROM COLUMN A "SALES " WHICH INCLUDE THE SALES VALUE BY USING DSUM BASED ON SPECIFIC NAME FROM COLUMN B "NAMES " AND WITHIN SPECIFIC DATE FORM COLUMN C"DATES" ALSO BASED ON SPECIE COUNTRY FROM COLUMN D" COUNTRIES" HOW I CAN SET THE FORM APPRECIATE YOUR HELP MICHAEL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Using DSUM, I need to evaluate 2 criteria that are not toge | Excel Worksheet Functions | |||
Criteria problems in the DSUM function | Excel Worksheet Functions | |||
DSUM with Criteria containing non-hardcoded values? | Excel Worksheet Functions | |||
Disjoint range for DSUM criteria | Excel Worksheet Functions | |||
conditional criteria in DSUM | Excel Discussion (Misc queries) |