Count based on criteria

  • Thread starter Thread starter Max2073
  • Start date Start date
M

Max2073

I have a spreadsheet with 8000 rows.

In column "I" I have text. eg. "Emily", "Greg" and "John"
In Column "D" I have numbers.

I need to count the rows where:

Column I is equal to Emily and Column D is < 30
Column I is equal to Greg and Column D is < 50
Column I is equal to John and Column D is < 70
 
=SUMPRODUCT((D1:D8000="Emily")*(E1:E8000<30))
=SUMPRODUCT((D1:D8000="Greg")*(E1:E8000<50))
=SUMPRODUCT((D1:D8000="John")*(E1:E8000<70))
 
Correction:

=SUMPRODUCT((I1:I8000="Emily")*(D1:D8000<30))
=SUMPRODUCT((I1:I8000="Greg")*(D1:D8000<50))
=SUMPRODUCT((I1:I8000="John")*(D1:D8000<70))
 
Back
Top