Home

Help!! With selecting a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-903420%22%20slang%3D%22en-US%22%3EHelp!!%20With%20selecting%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-903420%22%20slang%3D%22en-US%22%3ENeeding%20some%20help%20from%20someone%20in%20the%20know!%20If%20I%20have%20a%20series%20of%20data%20-%20say%204%20cells%20which%20contain%20numbers%200-3%20and%20I%20want%20to%20create%20a%20formula%20where%20I%20get%20a%20result%20of%20fail%20if%20more%20than%20of%20the%20cells%20are%200%20or%201.%20How%20do%20I%20do%20this%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20basically%20want%20a%20function%20to%20tell%20me%20if%20the%20series%20has%20more%20than%201%20cell%20with%20a%20value%20of%201.%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20the%20values%20could%20be%20any%20in%20combination%20e.g.%202%2C2%2C2%2C1%20or%202%2C1%2C2%2C1%20or%201%2C1%2C2%2C2%20I%20can%E2%80%99t%20use%20a%20total%20%26gt%3B%20formula.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-903420%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Gill_4711
New Contributor
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

Hi @Gill_4711 

 

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

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