This Week’s Tip : MS Excel – DSUM and DCOUNT

Posted in Weekly Tips

MS Excel – DSUM and DCOUNTExcel

DID YOU KNOW … that DSUM and DCOUNT allow you to be selective about which items you process and allow you to perform calculations that involve multiple fields and columns?

For example, if your spreadsheet contains a large amount of data perhaps for the whole year, use DSUM to add up only those entries for September. Easy to use when you know how.
Click the play button below to learn more.

Our Weekly Tips are sent via email every Tuesday. Learn something new every week – in Bite Size chunks of learning.  To sign up to our Weekly Tip Newsletters – sign up here.

Test the Water this Autumn – two great offers!

For Microsoft Office Only: Why not take a look at our special Three Month Taster for up to 100 staff to access all our Microsoft Office Libraries?


For Microsoft Office and Personal Development: Mix and Match any 10 e-learning courses from our Microsoft Office AND Personal Development Libraries with our Three Month Remote Working Offer?

Quick to set up and easy to register



Sign up for our free weekly tip

Receive a free nugget of IT Learning every week! It will give you a good feel for how we write and design our lessons and you could learn something new every week too!