An Alternative to Pivot Tables – Using Countifs, Sumifs and Averageifs

These functions can be a useful alternative to PivotTables. Both the PivotTable and stated functions have their pros and cons. In this session both will be discussed.

Sumifs and Countifs are advanced forms of Sumif and Countif functions respectively. They can work with single as well as multiple conditions.

In this 60 Minute fast-paced learning session, you’ll learn:

  • Countifs/Sumifs vs PivotTables
  • Countifs
  • Sumifs
  • Averageifs
  • Maxifs and Minifs (Office 365)

60 Mins

If you found this webinar interesting, InvestinU offers a range of training supports for Microsoft 365 which can be found here.

You can check out our FacebookInstagram, or Linkedin pages for more updates and to get in touch today!

Like this? Wanna see more webinars?

We have lots of different webinars on offer. To read more about them, click the button below.

   About InvestinU

   Meet The Team

   In the Media



   Microsoft 365 Webinars

   Microsoft 365 Consultancy

   Customised Training

   Bite-Size Learning


   Document Design

   Template Design

   Redesigning Documents

   Forms Creation (Word or Adobe PDF)

   Design Solutions

   Company Branding

   Logo Design


   E-commerce Websites

   Brochure Websites


   Social Media Management

   Content Creation (Blog)


   App Development

   Excel Automation

   Excel Dashboards / Reports

   Bespoke Database Systems

    Microsoft Packages

   Microsoft 365 Webinars

  Microsoft 365 Consultancy

   In-person Consultancy

   Invest365 Microsoft Ultimate