wrt1mea
asked on
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
See the attached for an example.
9-28-11.xlsx
Arno Koster
Easiest is to use a pivot table, like this : 9-28-11.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If I were you I'd do a pivot table. Project ID in the row field and (Average of) Days in the data field.
Here's an example:
=AVERAGEIF(A2:A25,J2,D2:D2
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
=AVERAGEIF(A2:A25,J2,D2:D2
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
Missed the refresh!
ASKER
Perfect! thanks to tall for the help, but this is the better solution for this particular situtation