LIST OF BLOGS MAINTAINED BY VIKRAM SHANKAR MATHUR SRNO BLOG URL GMAIL_ID 01 https://vsmathurcoin.blogspot.com vsmathurco@gmail.com 02 https://vsmathurcoinshop.blogspot.com vsmathurco@gmail.com 03 https://exceltrainerahmedabad.blogspot.com vsmathurco@gmail.com 04 https://vbabeginner.blogspot.com vsmathurco@gmail.com 05 https://ktvayedaco.blogspot.com ktvayedaco@gmail.com 06 https://ahmedabadfca.blogspot.com ahmedabadfca@gmail.com O7 https://vikramsmathur.blogspot.com vikramsmathur@gmail.com 08 https://cavsmathurin.blogspot.com cavs.mathur@gmail.com 09 https://cavsmathur.blogspot.com cavs.mathur@gmail.com 10 https://vsmathur380052.blogspot.com vsmathur380052@gmail.com 11 https:/’/vsmathur380054.blogspot.com vsmathur380054@gmail.com 12 https://vbacoder1962.blogspot.com vbacoder.1962@gmail.com 13 https://vsmathuricai.blogspot.com vsmathuricai@gmail.com 14 https://deadlyvbaprogrammer.blogspot.com deadlyvbaprogrammer@gmail.com   CA Vikram Shankar Mathur aka the DeadlyVBAProgrammer deadly...

I used ChatGpt to understand how to do this! See what I got as an answer - so blogging this !! ___________________________________________________________________________________  The DSUM() and DCOUNT() functions in Excel are part of Excel’s database functions, which allow you to perform operations based on specific criteria within a table-like range (database). 1. DSUM() Function The DSUM() function sums the values in a specified field (column) of a database that meet specific criteria. Syntax: excel Copy code DSUM(database, field, criteria) database : The range of cells that makes up the database (including headers). field : The column to sum, which can be the column header (in quotes) or the column number. criteria : The range that contains the conditions for selecting rows. Example: Let's say you have the following data in the range A1:C6 : Name Age Salary John 28 50000 Jane 34 60000 Mike 28 55000 Anna 40 70000 Chris 34 48000 You want to sum the salaries for people aged 28....