View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips
 
Posts: n/a
Default 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