Hi there. I am trying to write a Countifs formula where two of the columns have multiple criteria, but I can't seem to get it to work. This is what I have gotten to work so far:
=COUNTIFS('Jan21'!$A:$A,$B5,'Jan21'!$H:$H,"DOM",'Jan21'!$L:$L,1) - this will return the correct number (7)
but I need column H to be include either DOM or INTL, and L to count 1-21 inclusive. I could write it as
=COUNTIFS('Jan21'!$A:$A,$B5,'Jan21'!$H:$H,"DOM",'Jan21'!$L:$L,1)+COUNTIFS('Jan21'!$A:$A,$B5,'Jan21'!$H:$H,"INTL",'Jan21'!$L:$L,1)+COUNTIFS('Jan21'!$A:$A,$B5,'Jan21'!$H:$H,"DOM",'Jan21'!$L:$L,2)+COUNTIFS('Jan21'!$A:$A,$B5,'Jan21'!$H:$H,"INTL",'Jan21'!$L:$L,2)
etc, all the way to 21, but that would be a horribly long formula with 42 parts. Is there a condensed way of writing this?
Many thanks.
Bookmarks