This seems to be working:
=SUMPRODUCT(--(F2:F1000="cashier"),--(G2:G1000=2),(S2:S1000))

tj

"Sarah" wrote:

I need to know how to write a formula to average the
items in cells s2:s1000 when the titles in cells f2:f1000
= cashier and the review scores in cells g2:g1000 = 2.

I appreciate any help!

Sarah