Formula to figure an average on a range of cells with an "if"
nope - no dice - get the #DIV/0! error
"Mike H" wrote:
Hi,
Try this
=AVERAGE(IF(F1:F20="Yellow",G1:G20,FALSE))
This is an ARRAY formula so commit the formula by pressing Ctrl+Shift+Enter
NOT just Enter. If you do it correctly Excel will put curly brackets around
it {}. You can't type these yourself.
Mike
"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!
|