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!”
Here are some problems that our users have asked and received explanations on
In cell B12, add an AVERAGEIF function that will find the average call length for the Dept named range and the criteria specified in cell A12.
In cell C12, add a COUNTIF function that will count the number of calls for the Dept named range and the criteria specified in cell A12.
In cell D12, add a formula that sums two COUNTIFS formulas. The first COUNTIFS will count the number of calls associated with the Dept named range and criteria specified in cell A12 that received a grade F, and the second COUNTIFS will do the same for grade D.
Solved by X. Q. in 19 mins
Need help tweaking a COUNTIF formula.. Max number of arguements
Solved by S. C. in 12 mins
I need help with formulas countif, etc
Thank you
Solved by X. L. in 12 mins
I have a file with items in every other column with a corresponding number in the cell to the immediate right of the item. I need to use something like a countif to add up the number of times each is mentioned per row. It would make more sense it I sent you my mock spreadsheet.
Solved by O. J. in 19 mins
Countif A collumn of dates is less than a date in a specific date.
=COUNTIF(D3:D438,"<E575")
Did not work.
Solved by T. B. in 25 mins
I am creating a league table using the following formula but if 2 names have the same amount of sales it is duplicating the first name on the list.
=INDEX($E$2:$J$2,MATCH(1,INDEX(($E$34:$J$34=LARGE($E$34:$J$34,ROWS(P$13:P15)))*(COUNTIF(P$13:P15,$A$2:$J$2)=0),),0))
Solved by C. C. in 26 mins
wanting to create a vlookup on a name and provide the countif in a particular format
Solved by S. Q. in 26 mins
i need to add the countif and averageif function in excel to the project im working on.
Solved by S. C. in 22 mins
please figure it out =IF(COUNTIF($F9:K9,">0")<$E9,IF(AND(IF(AND(MONTH($B9)=MONTH(K$3),YEAR(K$3)=YEAR($B9)),$A9/$E9,IF(SUM($F9:K9)=$A9," ",K9))<>" ",IF(AND(MONTH($B9)=MONTH(K$3),YEAR(K$3)=YEAR($B9)),$A9/$E9,IF(SUM($F9:K9)=$A9," ",K9))<>0),IF(K$2<>"",K$2*$A9,0),IF(AND(MONTH($B9)=MONTH(K$3),YEAR(K$3)=YEAR($B9)),$A9/$E9,IF(SUM($F9:K9)=$A9,"",B9,K9))),"")
Solved by D. J. in 20 mins
I need to be able to count certain letters as numbers and then add them all up
=((COUNTIF(P19:P28,"A")*12),(COUNTIF(P19:P28,"B")*12),(COUNTIF(P19:P28,"C")*8),(COUNTIF(P19:P28,"D")*8),(COUNTIF(P19:P28,"E")*12),(COUNTIF(P19:P28,"F")*8),(COUNTIF(P19:P28,"G")*12),(COUNTIF(P19:P28,"H")*8),(COUNTIF(P19:P28,"I")*12)) this is what I was trying to use
Solved by V. F. in 24 mins