Summing Functions for Accountants

 Price: $25 incl GST

Duration: 1 hour

Everyone uses the SUM function, but have you ever used a 3D SUM function? This technique is flexible and allows you to easily include or exclude sheets from totals.

Do you know how and why to use SUMIFS function?

Did you know you can use Wildcard characters with SUMIFS?

Are you aware of two limitations of SUMIFS?

Discover some of the powerful uses of SUMPRODUCT.

Find out why you shouldn’t use the SUM function for subtotalling and how you should do subtotals.

Also learn about a function that was added in Excel 2010 that can ignore error cells when summing.

Date: October 20, 2020
Time: 1:00 PM AEDST
Event: Summing Functions for Accountants
Topic: Excel Summing Functions
Public: Public
Registration: Click here to register.