Forum Discussion
How to use COUNTIFS function if it overlaps between with different criteria
AmyYang See attached.
The key to all these calculations is the FILTER function. You can study the help pages to gain an understanding on how this function works. Combining criteria with the + sign works like a logical OR operation. When you use the * sign it's like AND.
Once you have narrowed down the dataset by filtering, you can apply COUNTA and MEDIAN.
AmyYang See attached.
The key to all these calculations is the FILTER function. You can study the help pages to gain an understanding on how this function works. Combining criteria with the + sign works like a logical OR operation. When you use the * sign it's like AND.
Once you have narrowed down the dataset by filtering, you can apply COUNTA and MEDIAN.
Riny_van_Eekelen Hi Riny, thanks so much for your follow-up feedback, that makes a lot of sense! Thanks for sharing and teaching.
Regards,
Amy