Forum Discussion

KattSwann's avatar
KattSwann
Copper Contributor
Apr 27, 2020
Solved

Counting "Pass" in a row in

How do I write a formula that can count how many times the word "Pass" comes up in a row of data? Thanks in advance.
excel
  • Zack Barresse's avatar
    Zack Barresse
    Apr 27, 2020
    =COUNTIF(1:1,"Pass")

    The above formula will count all cells with a value of "Pass" in row 1 of the sheet.
Zack Barresse's avatar
Zack Barresse
Iron Contributor
Apr 27, 2020
=COUNTIF(1:1,"Pass")

The above formula will count all cells with a value of "Pass" in row 1 of the sheet.

Resources