Forum Discussion
I'm struggling with COUNTIFS/SUMIFS
Take a look at the FILTER function. It can be used to filter a database with multiple criteria. It can be nested in a COUNT function that counts the number of rows that were produced by FILTER. This YouTube video also serves as a helpful introduction to FILTER.
If you still need more help, let me recommend that you post a copy of your existing workbook on OneDrive or GoogleDrive and paste a link here that grants edit access.
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!
