Help!!! Formula doesnt work.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Response to nesting problem - 10 Nov 2007 01:16 GMT

This was the formula that was given to me to accomplish my task:
=Average(Indirect("G1:G"&E7)). However it doesn't work or I have done
something wrong in entering the formula. Here is a jpeg of what I am trying
to do and hopefully I will get a better result this time around.
http://gallery.photoshack.com/displayimage.php?pos=-6162 and here is another
hopefully with a better explanation:
http://gallery.photoshack.com/displayimage.php?pos=-6197

Reply to this Message

Gary Keramidas - 10 Nov 2007 02:39 GMT

will this do what you want?

=SUMIF(O1:O384,"<"&E4&"")/COUNTIF(O1:O384,"<"&E4&"")

Signature

Gary

> This was the formula that was given to me to accomplish my task:
> =Average(Indirect("G1:G"&E7)). However it doesn't work or I have done
[quoted text clipped - 3 lines]
> hopefully with a better explanation:
> http://gallery.photoshack.com/displayimage.php?pos=-6197

Reply to this Message

Response to nesting problem - 10 Nov 2007 05:30 GMT

I want to thank you very much for solving my hair loss problem...lol
with what you gave me I was able to reduce the formula a bit so that it isnt
so extensive and still does what you originally gave me.
=SUMIF(AD3:AD302,"<="&E7)/E7 as well as i needed "<="&E7 instead of just
"<"&E7.
But none the less you have solved my delima.

> will this do what you want?
>
[quoted text clipped - 7 lines]
> > hopefully with a better explanation:
> > http://gallery.photoshack.com/displayimage.php?pos=-6197

Reply to this Message

Gary Keramidas - 10 Nov 2007 05:56 GMT

glad you got it worked out.

Signature

Gary

>I want to thank you very much for solving my hair loss problem...lol
> with what you gave me I was able to reduce the formula a bit so that it isnt
[quoted text clipped - 16 lines]
>> > hopefully with a better explanation:
>> > http://gallery.photoshack.com/displayimage.php?pos=-6197

Reply to this Message