COUNTIF statement - if there is a number greater than zero then it counts as one

I think I need to use a countif statement but I am unsure how to incorporate this formula. If there is a number in one of those cells greater than zero under the 'Service Type', 'Project ID', 'Project End Date', 'Reason for Termination' or 'Resource posted time?' columns then for that person in the PRM column it should count it as 1.

I have tried and IF OR and COUNTIF

1st Formula resulted in #UNPARSEABLE

=IF(OR(Category8 = <>"",[Service Type]@row = "",[Project ID]@row = "",[Project End Date]@row = "",[Reason for Termination]@row = "", [Resource posted time?]@row = "", ), 1)

2nd Formula resulted in #INVALID OPERATION

=COUNTIFS(Category9:Category9, CONTAINS(">0", [Service Type]@row, [Project ID]@row, [Project End Date]@row, [Reason for Termination]@row, [Resource posted time?]@row))

Find more posts tagged with

Formulas

Accepted answers

Adriane Price

This formula worked: =IF(SUM([Service Type]@row:[Resource posted time?]@row) > 0, 1, 0)

All comments

Adriane Price

This formula worked: =IF(SUM([Service Type]@row:[Resource posted time?]@row) > 0, 1, 0)

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.