Thanks Bob, but I can't get it to work. It looks like the formula only
takes into account the first record in the array. Am I doing something
wrong? Thanks!

"Bob Phillips" wrote in message
...
=IF(A1:A100="Y",B1:B100)

this is an array formula, so commit with Ctrl-Shift-Enter. It also means
that you cannot use a whole column, just a specific range.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steph" wrote in message
...
Hi. Is there a way to do an average if? Basically, if the contents of
column A is "Y", then include the contents on column B in the average?
Thanks!