I'm having trouble getting countifs to work when I have multiple criteria that needs to be matched to a cell range. It seems to work with no issue when there is one criteria and one cell range in a countif statement, but will not work with multiple criteria in a countifs function. The only way I made it work is do a sum and count each criteria individually. It seems there has to be a better way to do it. The attached spreadsheet is a simple example of what I'm trying to do. I've left the formula with the error as well.
Thanks in advance.
Bookmarks