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

If cell=X, countif range=y. Help needed. Thanks
Solved by I. J. in 19 mins
need a help ''=SUM(COUNTIF('Parts NC Entry'!$E$2:$E$5000,M15)+COUNTIF('Parts NC Entry'!$E$2:$E$5000,N15))-D15-SUM(COUNTIFS('Parts NC Entry'!$E$2:$E$5000,M15,'Parts NC Entry'!$G$2:$G$5000,"TRIAL/SETUP")+COUNTIFS('Parts NC Entry'!$E$2:$E$5000,N15,'Parts NC Entry'!$G$2:$G$5000,"TRIAL/SETUP"))=COUNTIFS('Parts NC Entry'!$E$2:$E$5000,M9,'Parts NC Entry'!$J$2:$J$5000,"X",'Parts NC Entry'!$H$2:$H$5000,"STPL-Vapi")+ COUNTIFS('Parts NC Entry'!$E$2:$E$5000,M9,'Parts NC Entry'!$J$2:$J$5000,"X",'Parts NC Entry'!$H$2:$H$5000,"SNIPL-Vapi")+Hlookups(COUNTIFS('Parts NC Entry'!$E$2:$E$5000,N9,'Parts NC Entry'!$J$2:$J$5000,"X",'Parts NC Entry'!$H$2:$H$5000,"STPL-Vapi")+ COUNTIFS('Parts NC Entry'!$E$2:$E$5000,N9,'Parts NC Entry'!$J$2:$J$5000,"X",'Parts NC Entry'!$H$2:$H$5000,"SNIPL-Vapi")
Solved by D. C. in 11 mins
I have a sheet for my real estate listings for my office. I have a Countif forumla counting any cells with text for my totals. But sometimes, two agents will split a listing. This means that each agent gets .5 credit for that one listing. The listing counts as 1, but each agent gets .5 credit. Is there any way to set up the totals to give half credit when more than one item is selected in the drop down?
Solved by D. H. in 13 mins
Using Microsoft Excel Index function, Match function, CountIf function, SumIf functions and Pivot Tables, please answer the question in data sample.
Solved by A. H. in 27 mins
I want to total the instances of football (soccer) matches ending in different scores at Half Time. I have 2 columns for HT score, for the home team and away team. I keep trying variations of countif, sumif, sumproduct if but if it works at all I seem to end up with a count of the instances of team scores rather than the instances of match scores, i.e. a 0-0 comes out as 2 (nils) instead of 1 (nil-nil)... add another score of, say, 1-0 and I end up with 2 or 3 (nils) depending on what I'm trying. I need a formula that manages to give me the instances of 0-0s, 1+ goals, 2+ goals, etc. In my file you can see where I enter score lines in the Scores tab... and where I need the formula in the Goals 4 tab - this currently is full of the formula that doesn't work.. except B4 and B5... I've just left it there in case there is an easy tweak rather than a full rewrite.
Solved by D. E. in 22 mins
Column of Date of Births (DOB), compared to TODAY, give me an AGE column expressed in Years and Months. ie. "2 Years, 0 Months" I'm using this working formula to derive that Age column: =DATEDIF(E2,TODAY(),"Y")&" Years, "&DATEDIF(E2,TODAY(),"YM")&" Months " I'm then trying to use mulitple conditions for a COUNTIF formula, one being if the subject is under/over one year old. Can I pull age from the "2 Years, 0 Months" column? or do I have to compare Date of Birth against TODAY again to derive the age in a simpler form?
Solved by C. J. in 19 mins
Good morning, I have a spreadsheet with Filtered Columns (call it "school") and CountIf Formula in five other columns (call them "National Awards", "Drop Out ", "Improved Attendance", "Improved Attitude" and "Improved Behaviour" When I filter the "school" column in to separate schools then the count if formula doesn't recalculate. Please help
Solved by X. U. in 15 mins
problem with countif function, it does not appear, i have excel 2016
Solved by O. H. in 13 mins
Hi, I have to create a COUNTIF formula. I need to count how many times a range of data (B5:K28) in 10 days exceeds its limit (value in cell O2) only if the status of the day (on/off) is equal to 1 (can be seen in B2:K2). If the status on/off is lesser than 1, ignore.
Solved by Z. J. in 24 mins
Need help putting together formula where it counts the number of sales but only if the average annual premium is above $360. So a sales = Sum(N:2:N:48)/360....but not greater than COUNTIF(N:2:N:48) ""
Solved by O. J. in 28 mins