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))
Adriane
Best Answer

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

This formula worked: =IF(SUM([Service Type]@row:[Resource posted time?]@row) > 0, 1, 0)
Adriane
Help Article Resources
Categories
Check out the Formula Handbook template!