Hi,

I guess that's an Excel 2007 enhancement?

Mike

"Lars-Åke Aspelin" wrote:

On Tue, 5 Aug 2008 11:40:00 -0700, lucyo912
wrote:

I have a spreadsheet that has a formula in column g that is an "if" formula
for the data in column f. I need to get an average of the data in column
"g". For example

column f column g
yellow 2
green 3
red 1
red 1
red 1
average yellow need formula for this

help!

Try this formula in cell G6:

=AVERAGEIF(F1:F5, "=yellow", G1:G5)

Hope this helps / Lars-Åke