HOW TO USE DSUM WITH MORE THAN ONE CRITERIA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dsum Help 0
Problem with criteria for DSUM (Excel XP) 2
Problem with DSUM (Excel XP) 1
Sum with multiple conditions - sumproduct, dsum or dproduct? 3
Dsum Problem with date criteria 1
Parameter Query with DSum 1
dsum - 1
DSUM criteria 3

Back
Top