Countif except N/A's

Rayme

I have two columns that I'm trying to build a countif function for. First column has a value: A,B,C. Second column is checkboxes with N/A if the team member is not required to complete. End result I would like to get a final count of all the A's that are required to complete the training.

=countifs(columnA:columnA, "A", columnB:columnB, <> "N/A")

Bassam Khalil

Hi @Rayme

Hope you are fine, please try the following formula:

=IFERROR(COUNTIFS(columnA:columnA, @cell = "A", columnB:columnB, NOT(@cell = "N/A")), "") 

the following screenshot shows the result:

Bassam Khalil

Hi @Rayme

Hope you are fine, please try the following formula:

=IFERROR(COUNTIFS(columnA:columnA, @cell = "A", columnB:columnB, NOT(@cell = "N/A")), "") 

the following screenshot shows the result: