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
|