Forum Discussion
I'm struggling with COUNTIFS/SUMIFS
Hello there, I am self taught using excel and as a result I can do some tricks quite well but have gaps with even some of the most basic functionality. I also struggle a little with a lot of the...
Thank you mathetes I really appreaciate you taking the time to point me in the right direction.
Let us know if FILTER was what you needed, i.e., did it work? I know that I've found it to be one of the most useful of functions ever since it was released, in particular because it can solve precisely the quandary you found yourself in, a need for IF (and related functions like SUMIF and COUNTIF) to be used in conjunction with numerous criteria.
It also comes in handy in sifting and sorting through databases for other purposes.
So enjoy that tool!