Count based on criteria

[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

 

[Gary''s Student]

=SUMPRODUCT((D18000="Emily")*(E1:E8000<30))
=SUMPRODUCT((D18000="Greg")*(E1:E8000<50))
=SUMPRODUCT((D18000="John")*(E1:E8000<70))

 

[Gary''s Student]

Correction:

=SUMPRODUCT((I1:I8000="Emily")*(D18000<30))
=SUMPRODUCT((I1:I8000="Greg")*(D18000<50))
=SUMPRODUCT((I1:I8000="John")*(D18000<70))