Try this:

F1: =SUMPRODUCT(--((E1:E1000)={5,6,7,8})*(D1:D1000="apple"))
(Note: Commit that formula by just pressing [Enter].

If 1000 rows isn't enough, just change that reference.

Does that hellp?
--
Regards,
Ron