Formulas > =DSUM()
How to Use DSUM() in Google Sheets
Description
How To Actually Use DSUM() in Sheets
DSUM(database, field, criteria)
Try DSUM yourself
In the range A1:C10, use the DSUM formula to calculate the total sales for the product category specified in cell E1. The criteria for the category should be in the range E1:E2.
Hints (2)
-
Make sure to reference the correct column for sales.
-
Check that your criteria range includes the header and the value.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the DSUM() formula:
Generate a DSUM() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses DSUM(). 2 free AI generations, no signup. Members get unlimited use.
Generate a DSUM() formula