Average of Results

**cas8100** · 11-04-2009, 11:25 AM

Is it possible to average the results of a given formula? What I'm trying to avoid is the creation of an extra column to perform the math function.

Example: Average of C-A for all columns. I tried =Average((C-A)

C-A)) but of course excel didn't like that....

Also tried =Average((C2-A2)

C200-A200)) but that didn't work either.

Thanks!

**cas8100** · 11-04-2009, 11:27 AM

Ha.. Those smilies should be part of the formula, let me try that again:

=Average((C-A) : (C-A))
AND
=Average((C2-A2) : (C200-A200))

**NBVC** · 11-04-2009, 11:32 AM

It's not clear to me exactly what you are saying...

You want to average all the differences between each row of columns C and A?

**cas8100** · 11-04-2009, 11:35 AM

Exactly, but I'd like to do so without creating a column for the differences.

Example:
Cell D2 = C2-A2
...
Cell D200 = C200-A200
Cell D201 = Average(D2:D200)

If I could get away without column D, I could display the results of D201 in a single cell.

**NBVC** · 11-04-2009, 11:38 AM

TRy

=AVERAGE(C2:C200-A2:A200)

and confirm it with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear around the formula.

**cas8100** · 11-04-2009, 11:48 AM

Thanks, that's exactly it. To add some more complexity to it...

The values I'm subracting are times. HH:MM:SS. I need to somehow ignore rows when one or both of the enteries are missing.

Right now any time that excel computes a negative time, the whole thing goes caput.