Array Formula Question

D

Don

I have two columns. Column A lists Teams. There are multiple rows of the
same teams in the column. Column C lists sales. What I want to do is write
a formula that allows me to show the average sales of each team. I've tried

{=SUM((C4:C19)*(Team=B31))/COUNTIF(Team,B31)}

but I get some huge number that is greater than the total sales of all
teams. Can someone help me point out what I've done wrong. Any help would
be appreciated.
 

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

Sports summary sheet - think I put this in wrong place originally 1
Finding the weighted average of text that have been given values 1
Problem with formula for finding last greater than/less than or equal to value 2
Sports question. Finding points scored by specific team 2
list items from one table in another table based on value in first table 2
Averaging with IFs 2
SUMIF formula required to search for 2 diff values in 2 diff colum 7
If AND for large range of data 1

Top