Mastering Conditional Functions in Excel
Conditional functions like SUMIFS
and COUNTIFS
allow users to perform complex data analyses by setting specific criteria.
These functions are critical for data-driven decision making and can then be used as a part of more complex calculations.
Task
First, please download the dataset we'll be using in this section:
Now let's use these functions to gain some insights:
- Determine the total number of Hair Shampoos sold.
- Find out how many transactions involved purchasing more than one Toy.
Note
The data shown in the video may differ from the data in the task's dataset, so ensure that your answer is based on the data from the downloadable file, not the video.
1. How many Hair Shampoos were sold?
2. How many transactions included purchasing more than one Toy?
Thanks for your feedback!
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 6.67
Mastering Conditional Functions in Excel
Swipe to show menu
Conditional functions like SUMIFS
and COUNTIFS
allow users to perform complex data analyses by setting specific criteria.
These functions are critical for data-driven decision making and can then be used as a part of more complex calculations.
Task
First, please download the dataset we'll be using in this section:
Now let's use these functions to gain some insights:
- Determine the total number of Hair Shampoos sold.
- Find out how many transactions involved purchasing more than one Toy.
Note
The data shown in the video may differ from the data in the task's dataset, so ensure that your answer is based on the data from the downloadable file, not the video.
1. How many Hair Shampoos were sold?
2. How many transactions included purchasing more than one Toy?
Thanks for your feedback!