 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Hello forum bods! I'm having a spot of trouble with Excel and know there are some amongst you who are well versed in the dark arts of formulae building. Basically I have three criteria for a series of cells with one that's a constant. These are all IF with Yes or No as the answer. I need a count of how many there are that have the constant as Yes with either or both of the other two with Yes as the answer.
It's to show if something is under a trigger level (the constant) and also under stocked on one of or both of two product types. I've tried using IF, OR and COUNTIFS to no avail.
It's possible the above makes no sense as my brain has pretty much gone on strike. If anybody can provide an answer I'll send them bottled tears of joy through the post.
Not completely sure I have the scenario right but quick and ugly approach would be a new column with something like.
=IF(Constant="Yes",IF(B3="Yes",TRUE,IF(C3="Yes",TRUE,FALSE)))
Then a countifs true over the top of those to get the total.
=if(and(constant="yes",or(product1="yes",product2="yes")),needtorestock,dontneedtorestock)
Thanks Guys. Sunday Jumper there's a bottle of tears of joy on its way to you 😆
If you want more information would you not be better of with an if in seperate cells. If true it returns one if false it returns 0 then another column you sum them.
You xan then see whats its passed aswell as kniw that its exceded a threshold
Don't think that would work as SUM of all three wouldn't account for the variables in two and three. All three columns already have IF formulae behind them. I think the solution offered was the best for my scenario, but thanks for the input though. 🙂