dsum on multiple criteria

Ihave the following headings in a database


CSA Meeting Date Meeting type Company Inhouse Products/Funds JV Product 1 JV Product 2 Venue Sales Manager 2nd Manager (JP, KMcI SS) Inv. Manager Filenote Issued Working Day No. of Attendees Cancelled Pack Required Compliance Required Division Reason for no Compliance "Date sent to
Compliance" "Pack/Literature
Used" Pack Path




i want to use the Dsum to produce the total amount of managers met for a cvertain sales person for a certain type of meeting. I trued thr following but it is returninga #value

=DSUM(A27:V1028,13,AND(3=$BH3,9=BI$2,12<>0))

where 13 applies to the number of managers column
3 is the meeting type
9 is the managers name
12 ensures that its only counted if teh meeting note is done.

Please help.

I'm not sure your 3rd argument is correct.

Can you post a sample sheet... with names, etc changed to avoid confidentiality issues.

I'm not sure that it is easy to easy DSUM() this way...

Perhaps try an alternative: Sumproduct()

E.g. in BI3, enter formula:

Please Login or Register  to view this content.

copy it down and across your summary table.