Forum Discussion
Problem with combining 2 functions: Choose and CountIF
Hi, I had a challenge in Excel, Please see the image below ( Data as an example): 1) I use Choose Function and It worked well: =CHOOSE({1};Sheet1!$A$31:$A$39 & "|" & Sheet1!$B$31:$B$39 & "|" &...
COUNTIF requires a range as first argument. It does not accept an array such as the result of CHOOSE.
Try
=SUMPRODUCT(--(CHOOSE({1};Sheet1!$A$31:$A$39 & "|" & Sheet1!$B$31:$B$39 & "|" & Sheet1!$C$31:$C$39 )="1|5|1"))
If you don't have Microsoft 365 or Office 2021, you may have to confirm the formula with Ctrl+Shift+Enter.