I have got a table with information from a project.
How can I get average of the A) project cost with estimate type strategic and concept.
B) 😎 Average of management cost for projects with value > 10 million
I have got a table with information from a project.
How can I get average of the A) project cost with estimate type strategic and concept.
B) 😎 Average of management cost for projects with value > 10 million
If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
That's too much data for a sample workbook and I cannot see where you have mocked up what you want manually.
Not going to play guessing games - provide a better sample workbook, please.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
First formula: =AVERAGEIF($D$2:$D$713,"Strategic",$E$2:$E$713)+AVERAGEIF($D$2:$D$713,"Concept",$E$2:$E$713)
Second formula: =AVERAGEIF($E$2:$E$713,">10000000",$G$2:$G$713)
thanks Josephteh.
This helps.
AliGW,
I thought that i had reduced the rows numbers but looks like i forgot to save the file. I will be more careful next time. Apologies for this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks