Average Base on Multiple Columns

R

rlm

I am trying to understand DAVERAGE. However I do not think that this
is what I want.
May I have a pointer towards the function to use to produce the needed
result set from the data set?

Data Set
---------------------------
A B C
1 Team Type Time
2 Alpha 1 5.5
3 Beta 2 3.5
4 Alpha 1 5
5 Delta 3 4
6 Beta 2 2
7 Charlie 3 4

Needed Result Set - Avg Time
 
A

Ashish Mathur

Hi,

You could use a pivot table. Drag team to the row area, type to the column
area and time to the data area. Change the value field setting from Sum to
average

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
A

Ashish Mathur

Hi,

You cannot use the DAVERAGE() function with this format. For the Database
functions to work, you must have the criteria arranged in columns (not in a
matrix structure) as show by you. Alternatively, we will get the output in
the designated format for the DAVERAGE() and then recast the output in your
format

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
R

rlm

We are using Excel 2003.

I had never used a pivot table before - very easy to use.

Thank you for the responses. Thank you Ashish Mathur!
 

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

Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Sumproduct in matrix means 3
calculating average handling time 7
Countif 2
INDEX return multiple columns 1
formula to count occurrences using multiple columns 2
Finding the weighted average of text that have been given values 1

Top