|Date:||October 20, 2020|
|Time:||1:00 PM AEDST|
|Event:||Summing Functions for Accountants|
|Topic:||Excel Summing Functions|
|Registration:||Click here to register.|
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.