Hi

Maybe this is what you need:

=SUMPRODUCT(--(A1:A65535="xxx");--(E1:E65535="bbb");F1:F65535)

Regards,
Per

"Seeker" skrev i meddelelsen
...
Thus end row can auto change to the last row?
like
=SUMPRODUCT(--(A1:A"counta(A1:A65536)"="xxx"),--(E1:E"counta(A1:A65536)"="bbb"),(F1:F"counta(A1:A6 5536)"))
Regards