DSum and DAverage

Dear James

Thank you for attending our Excel courses!! I hope you enjoyed the course and benefited from it.

DSum and DAverage are used for the range where the database has to have firt row as column headings.

and teh criteria has to have at least one column which contains criteria.

Please refer to the following link for more information about DSum:

http://www.bettersolutions.com/excel/EDH113/KS443814543.htm

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Dear James


Further to my previous post if you have a certain example where you think you need to calculate using rows then please post that and may be there are some other functions or features of Excel that I may be able to recommend to you.


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007