Thanks a lot for your help.
Sorry but i am new at this, how do i click "yes"? to say that your
post has helped me?

On Jul 8, 12:19*pm, Luke M wrote:
Ooops, my mistake. Forgot to change it over from my workbook I was in. All
the I's should be Q's (the column theformulais in)

=IF(N2="","",IF(COUNT($Q$1:Q1)=0,AVERAGE($E$1:E2), AVERAGE(OFFSET($E$1,SUMPR**ODUCT(MAX(ROW($Q$1:Q1)* ($Q$1:Q1<""))),0,ROW()-SUMPRODUCT(MAX(ROW($Q$1:Q1)***(Q$1:Q1<""))),1))))

--
Best Regards,

Luke M
*Remember to click "yes"ifthis post helped you!*



"Redi" wrote:
Thanks for your response.
Whats in column "I"?

On Jul 8, 11:17 am, Luke M wrote:
In Q1:
=IF(N1="","",E1)
In Q2:
=IF(N2="","",IF(COUNT($I$1:I1)=0,AVERAGE($E$1:E2), AVERAGE(OFFSET($E$1,SUMPR**ODUCT(MAX(ROW($I$1:I1)* ($I$1:I1<""))),0,ROW()-SUMPRODUCT(MAX(ROW($I$1:I1)***(I$1:I1<""))),1))))

Copy down as desired. This will generate an average everytime N is not
blank, or numbers that have not previously been counted.

--
Best Regards,

Luke M
*Remember to click "yes"ifthis post helped you!*

"Redi" wrote:
Hi all, i need help puting together aformula.
on column "e" i have all numbers
on column "n" i have words but some cells are empty.
myformulawill be located on column "q"
ifcell "n1" is blank then "q1" should be blank, butifcell "n2" is
not blank, then i need the average of "e1" and "e2".
if"n3", "n4", and "n5" are blank, then "q3", "q4" and "q5" are blank,
butif"n6" is not blank, then average "e3:e6"

Let me knowifanyone can come up with something.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -