There is an AVERAGEIF function in Excel 2007 but not in earlier versions. If
you looked for it and didn't find it then you probably aren't using Excel
2007.

average the values in one column if another
column's value is true.

Assuming the true's are Boolean (logical) TRUE and not TEXT true.

This array formula** will work in any version.

Assuming that the range with TRUE doesn't contain any text or numbers.

=AVERAGE(IF(B1:B20,A1:A20))

Where A1:A20 are the values to average.B1:B20 is the range that might
contain TRUE.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"lisab" wrote in message
...
I'm trying to average the values in one column if another column's value
is
true. I know there is a sumif and a countif, but couldn not find an
averageif. Any help would be much appreciated!