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
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
exactly what i wanted.
many thanks