Averaging values in column A when certain criteria are met in
that did it! thanks so much.
"Jacob Skaria" wrote:
Try
(with blank entries in Y for mathcing records)
=AVERAGE(IF($C$2:$C$60000={"Jane","John","Joan","J ean"},$Y$2:$Y$60000))
(excluding blanks)
=AVERAGE(IF(($C$2:$C$60000={"Jane","John","Joan"," Jean"})*($I$2:$I$60000<""),$Y$2:$Y$60000))
If this post helps click Yes
---------------
Jacob Skaria
"VichyB" wrote:
I have values in column Y, and a number of different names in column C. I
would like to create an average of the Y values for a select group of the
names from C. I have tried the following two ways and get a #DIV/0! error
both times. Any help is appreciated!
{=AVERAGE(IF(($C$2:$C$60000="Jane")*($C$2:$C$60000 ="John")*($C$2:$C$60000="Joan")*($C$2:$C$60000="Je an"),$Y$2:$Y$60000))}
{=AVERAGE(IF($C$2:$C$60000="Jane",(IF($C$2:$C$6000 0="John",(IF($C$2:$C$60000="Joan",(IF($C$2:$C$6000 0="Jean",(IF($Y$2:$Y$60000))))))))))}
|