Forum home » Delegate support and help forum » Microsoft Excel Training and help » visual+basic+excel - Sum
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
visual+basic+excel - Sum
Resolved · Low Priority · Version Standard
Reply Wed 24 Oct 2007, 13:50Delegate Eunhye said...
For upcoming training course dates see: Pricing & availability
RE: sum
Hi Eunhye
Thank you for your question.
The SUMIF function allows you to ask Excel to look in a column for one specific criteria, and then find corresponding values from the same column or a different column and add those values together.
The DSUM function allows you to ask Excel to look for criteria from multiple columns and then find corresponding values and add them together.
So the main difference between them is that SUMIF allows you to look for criteria in one column only whereas DSUM allows you to look for criteria in more than one column.
I hope this helps.
Amanda
|