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

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!

Find more posts tagged with

Formulas

functionality

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.