array formula help

S

Sarah

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
 
T

tjtjjtjt

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

tj
 
S

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
 
T

tjtjjtjt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Would like to input 3 letters into a cell, each having a different numerical value 5
Combing a V Lookup result with ("00"&A2)*1 in same formula 4
Trying to find additional ranges outside of min, max, and average 2
Average formula 4
Adding or to previously provided Average If Array function 4
Need conditional formatting help!!! 1
Why did I use array formula - help 7

Top