Forum Discussion
Solved
countifs in Excel 365
Hi Hive I'm struggling with the below "countifs" statements. this is a simplified version of my actual formula, but I'm getting the same weird output. Basically, I'm trying to count up the numb...
If you have the most recent version of Excel, then the dynamic array function FILTER can be used, in conjunction with COUNT (as this image shows)... [You can use multiple criteria in FILTER as well]
Here's a video that Microsoft released to explain FILTER and a couple other Dynamic Array functions. Well worth learning about.
https://www.youtube.com/watch?v=9I9DtFOVPIg
Thanks for the quick response Sergei.
I don't understand though. 😞
What I was expecting to see with those values is a match for all rows, and therefore D2 should be a total of 3 and E2 a total of 1. I want the total count of rows matching the criteria.
Is there a better formula to use to achieve this?
Thanks
I don't understand though. 😞
What I was expecting to see with those values is a match for all rows, and therefore D2 should be a total of 3 and E2 a total of 1. I want the total count of rows matching the criteria.
Is there a better formula to use to achieve this?
Thanks
If you have the most recent version of Excel, then the dynamic array function FILTER can be used, in conjunction with COUNT (as this image shows)... [You can use multiple criteria in FILTER as well]
Here's a video that Microsoft released to explain FILTER and a couple other Dynamic Array functions. Well worth learning about.
https://www.youtube.com/watch?v=9I9DtFOVPIg
- Thanks Mathetes
exactly what i wanted.
many thanks