Hi,
I am trying to use countifs with two sets of criteria. The second argument needs to count if any values in a list (Sheet1!I1:I10) matches another list (Sheet2!A1:A3), where as the first argument just counts if a range (K1:K10) matches a single value (A2).
=countifs(Sheet1!K1:K10,A2,Sheet1!I1:I10,Sheet2!A1:A3)
Excel says this is not possible as the arrays are of different size.
Any idea of how to get around this? Thank you!
I am trying to use countifs with two sets of criteria. The second argument needs to count if any values in a list (Sheet1!I1:I10) matches another list (Sheet2!A1:A3), where as the first argument just counts if a range (K1:K10) matches a single value (A2).
=countifs(Sheet1!K1:K10,A2,Sheet1!I1:I10,Sheet2!A1:A3)
Excel says this is not possible as the arrays are of different size.
Any idea of how to get around this? Thank you!