COUNTIFS across columns with multiple options for one column

Lori Flanigan

I am trying to write a formula to count the number of columns across five nonadjacent columns that contain "Verified". The fifth column may contain "N/A" and also needs to be counted.

In the example, 5 should be the total count for both rows. I've tried adding multiple COUNTIFS, and it doesn't work.

Thanks in advance for your help.

Lori F.

Jeff Reisman

@Lori Flanigan

Try this. Each one of the COUNTIF formulas should equal 1 or 0.

=COUNTIF(A@row, "Verified") + COUNTIF(B@row, "Verified) + COUNTIF(C@row, "Verified") + COUNTIF(D@row, "Verified) + COUNTIF(E@row, OR(@cell = "Verified", @cell = "N/A"))

Jeff Reisman

@Lori Flanigan

Try this. Each one of the COUNTIF formulas should equal 1 or 0.

=COUNTIF(A@row, "Verified") + COUNTIF(B@row, "Verified) + COUNTIF(C@row, "Verified") + COUNTIF(D@row, "Verified) + COUNTIF(E@row, OR(@cell = "Verified", @cell = "N/A"))

Lori Flanigan

Thank you, Jeff! The OR part of the formula is what kept tripping me up. This worked. Much appreciated!

Lori