Thank you very much.
"Ron Coderre" wrote in message
...
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
|