array formula help
 

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

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

I am sorry, but I do not understand. I want to
average .. I thought Sumproduct only added.

Also, I do not know what you mean by your use of "--"
please advise.

I appreciate your help,
Sarah

-----Original Message-----
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

.

Sorry about that, Sarah. This averaged numbers in my sample:
=SUMPRODUCT(--(F2:F1000="cashier"),--(S2:S1000=2),(H2:H1000))/SUMPRODUCT(--(F2:F1000="cashier"),--(S2:S1000=2))

tj

"Sarah" wrote:

I am sorry, but I do not understand. I want to
average .. I thought Sumproduct only added.

Also, I do not know what you mean by your use of "--"
please advise.

I appreciate your help,
Sarah

-----Original Message-----
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

.

For what the -- does:
http://www.mcgimpsey.com/excel/doubleneg.html

tj

"Sarah" wrote:

I am sorry, but I do not understand. I want to
average .. I thought Sumproduct only added.

Also, I do not know what you mean by your use of "--"
please advise.

I appreciate your help,
Sarah

-----Original Message-----
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

.