Hi Bajrang, You can use sumifs() Function for this I think, or attached a sample file to better understand your Query,
Rajan. -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B Sharma Sent: Tuesday, August 16, 2011 12:53 PM To: MS EXCEL AND VBA MACROS Cc: rajanverma1...@gmail.com Subject: $$Excel-Macros$$ How to use Multiple criteria in DSUM function... Hello to Excel Experts and other users of this group. I've been looking everywhere about how to put several criteria in different cell ranges in: DSUM(database, field, criteria). I have a very large database and using Dsum and I am using different different criteria in different different columns. Normally you put for example A1:G2 and everything works fine. Now the problem is that I have quite many criterias that are common for several DSUM() and I would like to split the criterias into for example A1:D2 and G1:G2. I've triad DSUM(database, field, {A1:D2, G1:G2}) (cannot use arrays with refernces..), DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc. What can I do? If anyone has an idea please let me know !! B. Sharma -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
