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
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies