logo-wlogologo-wlogo-w
  • Home
  • Classes
  • Training
  • Consulting
  • Blog
  • Contact
✕
Cut and Paste Using Spike
October 23, 2019
5 GMAIL HACKS
November 13, 2019

Tired of using SUMIFS? TRY DSUM

November 5, 2019

When trying to sum values with conditions, SUMIFS has always been our go-to function. However, when there are too many conditions, going on adding criteria, selecting criteria ranges can be a hell of a task.

This is exactly where DSUM comes into play. D standing for database, and databases are huge.

Syntax: =DSUM(database, field, criteria)

Database: Select the main table with headings.

Field: Select the heading whose contents you want to sum.

Criteria: Select the table containing conditions with headings.

Here is an example showing sales of different countries done by different salesperson residing in the respective countries. You can use the DSUM formula here in the following way.

01 DSUM gif

Things to remember

⦁ When the criteria table is empty, DSUM gives the sum of all the values without any condition applied, just like a normal SUM function.

Picture 1

⦁ The criteria table should have the same formatting as in the database.

⦁ The “field” criteria in the formula can be filled with hard values, for example, here you can type ‘Sales’ (with the same formatting) instead of selecting G1 or C1.

Picture2

All 3 variations above, for the formula used in the example, give the same answers.

⦁ You can add as many conditions as you want in the criteria table and modify the formula accordingly.

02 DSUM gif

Contributor: Sonia Keswani

I am a B.Com(Hons.) graduate from South City College (Morning) and have been working at Leveraged Growth as a Finance Intern for the past 1 month. I am pursuing CFA and aspire to be a Financial Analyst in future.
IMG-20191023-WA0003_2
Share
2

Related posts

December 16, 2021

Stacking in EXCEL


Read more
December 9, 2021

SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW


Read more
November 25, 2021

Circular Referencing Solution


Read more

Comments are closed.

✕

Categories

  • Google
  • MS Excel
  • MS Word
  • Power BI
  • Uncategorized
  • Stacking in EXCEL
    December 16, 2021
  • SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW
    December 9, 2021
  • Tips and Tricks of MS PowerPoint
    December 3, 2021
  • Circular Referencing Solution
    November 25, 2021
  • Printing tricks
    November 18, 2021
    Disclaimer Policy | Terms of Service
    Powered by Aswini Aswini Bajaj
    Website Designed & Developed by 'A PIXEL HOUSE'