Get instant live Excel expert help with a COUNTIF Functions

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

On the 3 green tabs "LTV Graphs" use countifs to fill in data in range table excluding zeros.Then create a stack bar graph in all three green tabs using that data, define the Y Axis as "LTV Range" and the X axis as Loan Quarters. Use similar color sequence as the graph in red tabs
Solved by Z. J. in 26 mins
Trying to get a "countifs" formula to work and for some reason it won't count what I need it to.
Solved by M. E. in 19 mins
Need a formula --> Summary tab ---> Column F (1 med and 1 code) --> medications tab and diagnosis code tab. The formula I came up with was this.. however something is wrong. Need help. =IF(COUNTIFS(medications!C:C,C5)=1,"yes","no"),('diagnosis codes'!$C$5:$C$1750,summary!A5)=1,"yes","no") *Also need help understanding summary tab -> #risk factors How do I use the risk factor separate tab to solve this in the summary tab? Both parts go together please help
Solved by S. Q. in 27 mins
I have an excel sheet with two columns, both are numbered 1-4. They correspond to Pre and Post examination data for a group of students. more studnets took the pre exam than the post exam...but the data is only good if include studnets with BOTH pre and post examination. I am trying to count the # of students who obtained each score (1-4) on their pre examination who also obtained the follow up examination. Can I do this via countifs?
Solved by B. B. in 17 mins
Hello, I have an excel sheet containing information for pre and post test data, and I need to take averages of the data on ONLY students who recieved BOTH the pre and post tests. (students who recieved only pre or only post test will be eliminated) So far I have tried using the countifs function to help solve my problem," =AVERAGEIFS(X2:X122,"<=0",BD2:BD122,"<=0 " but I think that because the criteria are too similar...I am not getting a good result.
Solved by B. S. in 22 mins
what is this formula doing =(COUNTIFS(C$2:$C2,C2)<=MIN(COUNTIFS($C$2:$C$668,-C2),(COUNTIFS($C$2:$C$668,C2))))
Solved by O. J. in 26 mins
In need a formula IF column D is not blank AND column G OR column I OR column J is blank THEN "Pending" IF column D is not blank AND column G OR column I OR column J is not blank THEN "Closed" I have tried COUNTIFS, IFS, and can't get this to work. I don't know what I am missing. Each column is a DATE as well. I was thinking If DATEVALUE like whatever the date is then yada yada, but I can't get this rationale to work in excel AT ALL. I'm at a lost.
Solved by A. L. in 15 mins
I need to create a formula that counts the number of jobs matching specific criteria (e.g. overdue, due this week, due this month), over three sheets in the same file; AND displays the count in a cell- which I can then double click to bring up a table of those jobs (similar to pivot tables). I need to be able to save this formula in a template as the source data will change every week and I don't want to have to go through the bother of tweaking pivot tables every time. I've had no luck with countifs and sumproduct, as i cant seem to combine the three source data, and getting the cell "double click"option to bring up a table either.
Solved by V. S. in 19 mins
I need to use the countifs function to display this..... =COUNTIFS(E3:E237,">="&DATE(2018,8,6),E3:E237,"<="&DATE(2018,10,31),M3:M237,">="&100%) it is coming up as 0 when it should have a number of cells with that value
Solved by X. J. in 19 mins
how to use average function in excel? I would like to create a formula that creates an average and standard deviation based on two criteria (the name of the client and the role group).So I need to figure out how to analyze averageifs, countifs based on two criteria.
Solved by E. Q. in 22 mins