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

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