Average Function

[Trish]

I have one "master" worksheet with the salesperson's name
and their sales listed (among other things). I am trying
to use the AVERAGE and VLOOKUP functions to find all sales
by a particular salesperson and return their average - on
another worksheet. Should I be using AVERAGE and IF,
instead?

Any help would be appreciated.

 

[Jim]

=SUMIF(Salespersons,"Trish",SalesAmounts)/COUNTIF(Salespersons,"Trish")
where you have ranges named Salespersons and SalesAmounts

 

[Brandenkopf]

Assuming that the data is in a spreadsheet with Salesperson in column
"A", and Sales Amount in column "B", here is a formula you could use in
another sheet. The result of the formula would be the average sale for
the particular person. Use the formula as many times as you have
salespersons, just change the criteria in the formula.

=SUMIF(A:A,"=Jack",B:B)/COUNTIF(A:A,"=Jack")