Averaging percentage from 3 columns in one row

Paula D

I have 3 columns in one row and I'm trying to show the average of the percentage of work done from those three columns. I've attached a screen shot.

In one example, 25% is done from one column and 0% is done from the other two columns. The sum/average shows 54% complete

In the next example I actually made all 3 columns 100% complete and the average number that was returned was 54%. It should be 100% as all three columns are complete.

The formula I'm using in the %Complete column is:

=AVG([Integrated Testing]:[Functional Testing])

What am I doing wrong?

testing.jpg

Paul Newcome

Because you did not specify a row, you are averaging all three columns in their entirety. Try this instead:

=AVG([Integrated Testing]@row:[Functional Testing]@row)