3,887 questions
=COUNTIFS(I11:I67,">=3500", J11:J67,E3)
or (my pref.):
=COUNTIFS(I11:I67,">="&3500, J11:J67,E3)
Excel CountIfs
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 64%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Lori Hernandez
1
Reputation point
I am working on homework on excel and one of the questions is "You want to count the number of applications that meet two conditions. In cell H5, insert the COUNTIFS function to count the total number of applications that meet two conditions: Scores in the range I11:I67 are greater than or equal to 3500 and Final Decisions in the range J11:J67 are Early Admissions (cell E3). " and I cant seems to get the formula right. Ive tried like 50 different things but they still dont work. I need help on this please.
Microsoft 365 and Office Excel For business Windows
{count} votes
-
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff2021-03-01T08:20:19.973+00:00 Hi @Lori Hernandez ,
Just checking in to see if the information of Lz-3068 was helpful. Please let us know if you would like further assistance.
If you think my reply is helpful, I suggest you click "Accept Answer" and upvote it. Other partners who read the forums with the same issue can get more information from the correct result.
Thank you.
-
Lz._ 9,016 Reputation points2021-03-03T11:47:23.787+00:00 A well known side effect when solutions are delivered ;-) =>
Sign in to comment
1 answer
Sort by: Most helpful
-
Lz._ 9,016 Reputation points
2021-02-27T11:44:31.453+00:00 -
Lz._ 9,016 Reputation points
2021-03-04T09:10:52.68+00:00 @Lori Hernandez
Forums' contributors usually don't provide solutions in such situation (I am working on homework and one of the questions is...) - you can easily guess why. It's because you said "I've tried like 50 different things" that I replied
Hope this worked & wish you won't have another challenge...
Sign in to comment -