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

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