Hi Ken

Here is the range of cells

Cell A1
=+AVERAGE(IF(I$12:I$39=1,IF(ISNUMBER(AH$12:AH$39), IF(ISNUMBER(AG$12:AG$39),(AH$12:AH$39-AG$12:AG$39)))))

Cell A2
=+STDEV(IF(I$12:I$39=1,IF(ISNUMBER(AH$12:AH$39),IF (ISNUMBER(AG$12:AG$39),(AH$12:AH$39-AG$12:AG$39)))))

Cell A3
=+MEDIAN(IF(I$12:I$39=1,IF(ISNUMBER(AH$12:AH$39),I F(ISNUMBER(AG$12:AG$39),(AH$12:AH$39-AG$12:AG$39)))))

Cell B1
=+AVERAGE(IF(I$12:I$39=1,IF(ISNUMBER(AI$12:AI$39), IF(ISNUMBER(AH$12:AH$39),(AI$12:AI$39-AH$12:AH$39)))))

Cell B2
=+STDEV(IF(I$12:I$39=1,IF(ISNUMBER(AI$12:AI$39),IF (ISNUMBER(AH$12:AH$39),(AI$12:AI$39-AH$12:AH$39)))))

Cell B3
=+MEDIAN(IF(I$12:I$39=1,IF(ISNUMBER(AI$12:AI$39),I F(ISNUMBER(AH$12:AH$39),(AI$12:AI$39-AH$12:AH$39)))))

it goes on like that for 5 columns total.

I'd like to activate all these at once. There are several groups o
15, so it's time consuming to activate each one, which is why I'
looking for a way to do it en masse.

Thanks,
Karenn

--
Message posted from http://www.ExcelForum.com