Using COUNTIF and COUNTA to count items in a list

1
345

The ExcelHelpDesk Support team received the following request for help

Problem – checking for specific cell values

Please help me with a formula
I want to say that if columns B to BX = A or N/A then True, otherwise False.
I just can’t seem to find the right formuala!!!
Debbie…

Here is a sample of the file sent through that shows what was needed

Solution – Create a formula to set the Value

The formula needed to calculate the number of non-empty cells for each row and then compare that to the number of cells that had “A” or “N/A” included. If that number differed then the result needed to be FALSE, if it matched then the result was TRUE.

The formula needed was

=IF(COUNTA(B2:AX2)=(COUNTIF(B2:AX2,"A")+COUNTIF(B2:AX2,"N/A")),TRUE,FALSE)

If you have a question on this post for the Excel Help Desk team or have something you would like to share on this topic then please leave a comment