COUNTIF using OR
Hi,
I'm trying to count how many check boxes (out of a possible 4) are checked on a row (basically, countif w OR x OR y OR z is checked).
I've tried many variations of the following formula:
=COUNTIFS(OR[PNS]@row = "1", [EIP]@row = "1"))
Thank you!
Best Answer

If your column title contains a space, it must be surrounded with square brackets. This should fix it.
=COUNTIFS(PNS@row, 1) + COUNTIFS(EIP@row, 1) + COUNTIFS(Facilities@row, 1) + COUNTIFS([Patient Care Experience]@row, 1)
Answers

Are the wxyz column grouped together? If so, this should work:
=COUNTIFS(w@row:z@row, 1)

Unfortunately, the columns are not grouped together and I am unable to rearrange them :(

A little longer, but it will still work fine.
=COUNTIFS(w@row, 1) + COUNTIFS(x@row, 1) + COUNTIFS(y@row, 1) + COUNTIFS(z@row, 1)
Edit: Technically, you could use COUNTIF instead of COUNTIFS since it is only comparing one item. I just always use COUNTIFS for the sake of consistency.

I'm getting an error with this formula (which replaces the w/x/y/z with the actual column names):
=COUNTIFS(PNS@row, 1) + COUNTIFS(EIP@row, 1) + COUNTIFS(Facilities@row, 1) + COUNTIFS(Patient Care Experience@row, 1)

If your column title contains a space, it must be surrounded with square brackets. This should fix it.
=COUNTIFS(PNS@row, 1) + COUNTIFS(EIP@row, 1) + COUNTIFS(Facilities@row, 1) + COUNTIFS([Patient Care Experience]@row, 1)

Thanks for the reminder on that. It all works now. Thanks for your assistance!!

Awesome, I'm glad it worked for you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!