In my #ExcelTrainerAhmedabad identity (GST recognized) I wanted to impart Advanced Excel Training which would enable you to produce formats like this screenshot, as an Excel Worksheet / Workbook (macro-enabled). But I have given up the idea of training anyone ever,  because now I have no time to do this, see? Cheers!! In my opinion, I have gained a lot of free time by giving up and the loss is obviously to those who ought to have availed that opportunity!!

 Product-Catalog-Trial All of these will soon be available in my [DIGITAL SHOWROOM] To send me a message, visit my Contact Us Page here .

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....

20191211-DeadlyVBAProgrammer.com CA Vikram Shankar Mathur @DeadlyVBA.Programmer deadlyvba.programmer@gmail.com https://www.deadlyvbaprogrammer.com https://fb.me/deadlyvbaprogrammer https://m.me/deadlyvbaprogrammer December 10th, 2019 at approx 18:30 Hours IST, DeadlyVBAProgrammer became a Google Domain. Cheers !!

DISCUSSION SOURCE URL FOR CODING - USE THIS, WILL OPEN IN NEW WINDOW: https://www.kindsonthegenius.com/blog/2018/01/how-to-connect-python-to-excel-read-and-write-data-try-it.html Copyright @ 2019 - CA Vikram Shankar Mathur ( deadlyvba.programmer@gmail.com ) DeadlyVbaProgrammer.com