Get instant live expert help on count if condition
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to count entries in column X if there is specific condition in column Y
Solved by M. B. in 11 mins
Looking for the formula, if cell 1 condition is equals to cell 2 then it should count as 1.
Solved by Z. B. in 21 mins
Needing an IF statement for IF condition = terrible = "reject" IF condition = poor = low price offer IF condition = good, age of book under 15 years = offer low price offer IF condition = good, age of book is over 15 years, paperback = offer medium price offer IF condition = good, age of book is over 15 years, hardcover = offer high price offer
Solved by V. U. in 27 mins
I have a condition where the results of the excel (if and) formula count are negative and logically if the result is negative then zero (0) example: in the AA column the formula is = IF (AND (N19> K19, N19> AB19), Z19 * 1, N19-K19) if AA19 <0 (negative) then the result is 0 or AA19 * 1 how about the excel formula for the condition? thank you
Solved by M. S. in 16 mins
if condition if value is increasing it should show green. If value is decreasing it should go red accordingly via an if condition
Solved by G. J. in 23 mins