COUNTIFS with multiple columns
I'm using a COUNTIFS to count particular strings in a number of columns, and then also check that another string appears in another column. All columns are on another sheet.
It works when I count one string in a number of columns in the sheet only, and it also works when I count a particular string in one single column and a particular string in another single column, but when I try to count a particular string in a number of columns and a particular string in another single column, it doesn't.
Any ideas, thoughts?
Help Article Resources
Check out the Formula Handbook template!