How to use dsum and array formulas to perform specific calculations in Microsoft Excel

3,720 views · Published 31 October 2011 · 4:39 · Indexed 28 September 2026

Channel: Dinesh Kumar Takyar · 2011 · Education

Watch on YouTube

Welcome to http://familycomputerclub.com on youtube!
You can use dsum or array formulas to perform selective and specific calculations on your Microsoft Excel data. Dsum uses a criteria range just like the advanced filter. The array formulas are very powerful but you need to remember to press 'ctrl+shift+enter' keys simultaneously after writing the formula. In the formula box you'll notice curly brackets in the formula. This is essential or the array formula will not work.
http://www.youtube.com/watch?v=rLXXDOChV4Q

More from this channel

• 3:55 What are slicers in Microsoft Excel

  Dinesh Kumar Takyar

  1,913 views · 16 April 2011

• 4:03 if function Excel

  Dinesh Kumar Takyar

  1,631 views · 9 November 2011

• 4:12 Conditional formatting solution Microsoft Excel

  Dinesh Kumar Takyar

  383 views · 16 November 2011

• 5:00 Questions on date, currency, if and count functions

  Dinesh Kumar Takyar

  511 views · 25 March 2012

• 2:37 Collaboration in MS Excel using SkyDrive

  Dinesh Kumar Takyar

  2,603 views · 4 July 2012

• 15:37 Automating Managers Response Time Calculations in MS Excel

  Dinesh Kumar Takyar

  532 views · 19 September 2012

• 13:31 Graphs MS Excel - How to use them to avoid heavy calculations

  Dinesh Kumar Takyar

  502 views · 1 October 2012

• 0:07 HAPPY DIWALI

  Dinesh Kumar Takyar

  219 views · 13 November 2012