Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Complex Average
I am looking to find the average of a column of numbers, but the specific
cells in that column depend on the data in another column. I want to average the CPI of a column of project CPIs, but only if that project is in the active status. An example of my data will look like this: ProjectName CPI Phase Project1 .9 Active Project2 .6 Inactive Project3 1.1 Active I need the formula to average Project1 and Project3's CPI because they are active. Thanks John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average (geometric) | Excel Worksheet Functions | |||
average on 2 conditions | Excel Worksheet Functions | |||
calculate average hours and minutes | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions | |||
average, array and offsets | Excel Worksheet Functions |