Excel CountIfs

Lori Hernandez 1 Reputation point
2021-02-27T11:27:02.967+00:00

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.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,687 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Lz._ 8,991 Reputation points
    2021-02-27T11:44:31.453+00:00

    Hi @Lori Hernandez

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

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