I need an excel formula

I need an excel formula to calculate the average number of days for a specific Project ID, and display the results only once. I cant tell you how bad a screwed up the syntax on this one!

See the attached for an example.
9-28-11.xlsx
LVL 1
wrt1meaAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
In F2:
=IF(A2=A1,"",AVERAGEIF($A$2:$A$25,A2,$D$2:$D$25))
then copy down.
0
 
Arno KosterCommented:
Easiest is to use a pivot table, like this :  9-28-11.xlsx
0
 
StephenJRCommented:
If I were you I'd do a pivot table. Project ID in the row field and (Average of) Days in the data field.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
dlmilleCommented:
Here's an example:

=AVERAGEIF(A2:A25,J2,D2:D25)

Where J2 is the project Id, which is matched with A2:A25, and the average based on that comes from the data in D2:D25

See example attached,


9-28-11.xlsx
0
 
dlmilleCommented:
Missed the refresh!
0
 
wrt1meaAuthor Commented:
Perfect! thanks to tall for the help, but this is the better solution for this particular situtation
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.