question

LoriHernandez-9097 avatar image
0 Votes"
LoriHernandez-9097 asked ·

Excel CountIfs

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.

office-excel-itpro
· 2
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @LoriHernandez-9097,

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.

0 Votes 0 ·
Lz-3068 avatar image Lz-3068 emizhang-msft ·

A well known side effect when solutions are delivered ;-) => 73812-nointernetconnection.png


0 Votes 0 ·

1 Answer

Lz-3068 avatar image
0 Votes"
Lz-3068 answered ·

Hi @LoriHernandez-9097

=COUNTIFS(I11:I67,">=3500", J11:J67,E3)

or (my pref.):
=COUNTIFS(I11:I67,">="&3500, J11:J67,E3)

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@LoriHernandez-9097
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...

0 Votes 0 ·