• 464K Members
• 12K Online
• 560K Conversations

New Contributor

# Help!! With selecting a formula

Needing some help from someone in the know! If I have a series of data - say 4 cells which contain numbers 0-3 and I want to create a formula where I get a result of fail if more than of the cells are 0 or 1. How do I do this?

I basically want a function to tell me if the series has more than 1 cell with a value of 1.

As the values could be any in combination e.g. 2,2,2,1 or 2,1,2,1 or 1,1,2,2 I can’t use a total > formula.
2 Replies

# Re: Help!! With selecting a formula

You can achieve this by using Countif() function:

=COUNTIF(B3:F3,"1")

A sample file is also attached for your reference, please let me know if it works for you.

Thanks

Tauqeer

# Re: Help!! With selecting a formula

Thanks wasn’t the exact fix but used it then applied a IF formula to the result of that formula!!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies