How to include formula to perform a count from the keyword in the row and update the count?

Angeline Lai

Hi expert,

Not too sure if this is supported within the function. I have a used case below,

I need tester to input their test result in name assigned in the column (Col E-G).

Once they input the status = "P" or "F", the Column 'Total Pass' and 'Total Fail' will do the count base on the condition keyword P or F in each row and populate the number in the column B & Column C. Refer below sample.

Kindly advise. Many Thanks!

Mark Cronk

Try:

Total pass is: =COUNTIFS(TESTER1:TESTER3, "P")

Total fail is: =COUNTIFS(TESTER1:TESTER3, "F")

Total Incomplete is: =COUNTIFS(TESTER1:TESTER3, IS BLANK(@cell))

Help?

Mark

Mark Cronk

Try:

Total pass is: =COUNTIFS(TESTER1:TESTER3, "P")

Total fail is: =COUNTIFS(TESTER1:TESTER3, "F")

Total Incomplete is: =COUNTIFS(TESTER1:TESTER3, IS BLANK(@cell))

Help?

Mark

Angeline Lai

HI Mark,

Thanks for the swift response! Is working with slight tweak in the syntax! You save my day! 🤩

=COUNTIF([Tester1]@row:[Tester5]@row, "P")

=COUNTIF([Tester1]@row:[Tester5]@row, "F")

=COUNTIFS([Tester1]@row:[Tester5]@row, ISBLANK(@cell))

Mark Cronk

Glad to help. Thank you for contributing to the Community.

Mark