BloomTech’s Downfall: A Long Time Coming

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

COUNTIFS or SUMPRODUCT for Complex Counting Formula - 3 Examples

ExcelIsFun via YouTube

Start learning Write review

Overview

Learn how to count open projects by day and project code, including empty cells, using complex criteria in Excel. This course covers the COUNTIFS and SUMPRODUCT functions, teaching you how to handle "Not Empty Cell" and "Empty Cell" syntax, as well as incorporating both AND and OR logical tests in your formulas. The course includes three examples demonstrating different scenarios for complex counting formulas. The intended audience for this course is Excel users looking to enhance their skills in advanced Excel functions and criteria-based calculations.

Syllabus

) Introduction.
) SUMPRODUCT Function Formula..
) Two COUNTIFS Functions Formula.
) SUMPRODUCT & COUNTIFS functions in same formula, with a Function Argument Array Operation in the COUNTIFS..
) Summary.

Taught by

ExcelIsFun

Reviews

Start your review of COUNTIFS or SUMPRODUCT for Complex Counting Formula - 3 Examples

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.