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

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