Excel DSUM Function – Notes and Example

What does DSUM do?
The DSUM function is used to calculate the sum of values in a database (table) based on given criteria.
It works only when data is arranged in a proper table with headings.

Syntex :- 
=DSUM(database, field, criteria)

Arguments
Database – Select the complete table including headers
Field – Column name or column number to sum
Criteria – Range containing conditions

Example Data Table :-




Formula Example :- 

Database › whole table
Field › Qty
Criteria range › Product
                                Laptop 





Use of Dsum »

→Sales reports
→Brand-wise totals
→Category-wise analysis
→Simple database-style calculations

Note :-
DSUM works only when:
Table has proper headers
Criteria range also includes headers

Watch on YouTube ⟩ DSUM Function 

Comments

Post a Comment

Popular posts from this blog

Excel DGET function - Notes and Example

Image
What does DGET do ? The DGET function is used to find a single value from a database (table) that matches the given condition (criteria). It returns a result only when one unique record satisfies the criteria. Syntax =DGET(database, field, criteria) Argument Explanation :- Database -  Select the complete table including column headings. Field- Select the column number or column heading from which the value is required. Criteria- Select the range that contains column heading with condition. Example Table :- Formula Example:-  Database › whole table Field › Sales Criteria Range › First Name                                 Neha Important Note - • The criteria must return only one matching record. • If no record or multiple records match, Excel returns an error. Watch on YouTube > DGET function  
Read more

Excel DAVERAGE Function – Calculate Average Using Criteria

Image
🔹 What is DAVERAGE Function? DAVERAGE function is used to calculate the average value from a database table based on given criteria. It works on database-style data. 🔹 Syntax =DAVERAGE(database, field, criteria) Database:- Complete data range including column headings. Field:-    The column for which average is required (can be column name in quotes or column number). Criteria :-  A separate criteria range with heading and condition. 🔹 Example Data Table Use of formula:-    🔹 Result Explanation DAVERAGE calculates the average of the selected column only for records that match the criteria. Rows that do not satisfy the condition are ignored. 🔹 Where DAVERAGE is Used Average sales based on brand Average marks of students Average salary by department Report-based data analysis 🔹 Important Points Headings are mandatory Criteria range must include heading Only numeric values are averaged Works best with structured data
Read more