do u want to average where coresponding cell is " marked as "yes"?
Paul
On Wed, May 13, 2009 at 5:05 PM, Damian wrote:
>
> Hi Andy
>
> thank you for reply & sorry for small delay...
>
> I have range of data C1:E10 and A1:A10 each cell got drop down list
> with values: "Yes" and "No". for exampl
Hi Damian,
You can attach the worksheet with the reply email.. or directly send at
aind...@gmail.com
Regards,
Andy
On Wed, May 13, 2009 at 6:35 PM, Damian wrote:
>
> Hi Andy
>
> thank you for reply & sorry for small delay...
>
> I have range of data C1:E10 and A1:A10 each cell got drop down li
Hi Andy
thank you for reply & sorry for small delay...
I have range of data C1:E10 and A1:A10 each cell got drop down list
with values: "Yes" and "No". for example i change values in A1, A4 and
A7 to "No" and i don't want the corresponding rows C1:E1, C4:E4 and
C7:E7 were taken into average calc
Hi Damian,
could you explain the part "without taking into account a few cells from
that range"
Is there any specific parameter for that... or is that random.
It would be better if you attach a sample worksheet that will help visualize
the data properly.
Regards,
Andy
On Sun, May 10, 2009 at 7:1
