G
Gary
=AVERAGE(IF(Start:End!C22<>0,Start:End!C22,""))
Hi All can anyone tell me what's wrong with the above mentioned formula? I
am pressing CTRl+SHIFT+ENTER.
What I am trying to do here is, take the average of cell C22 from all the
sheets between the two sheets named as Start and End ignoring all the zero
values.
Thanks for any help.
Gary
Hi All can anyone tell me what's wrong with the above mentioned formula? I
am pressing CTRl+SHIFT+ENTER.
What I am trying to do here is, take the average of cell C22 from all the
sheets between the two sheets named as Start and End ignoring all the zero
values.
Thanks for any help.
Gary