Conditional if formula.
In Q1:
=IF(N1="","",E1)
In Q2:
=IF(N2="","",IF(COUNT($I$1:I1)=0,AVERAGE($E$1:E2), AVERAGE(OFFSET($E$1,SUMPRODUCT(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" if this post helped you!*
"Redi" wrote:
Hi all, i need help puting together a formula.
on column "e" i have all numbers
on column "n" i have words but some cells are empty.
my formula will be located on column "q"
if cell "n1" is blank then "q1" should be blank, but if cell "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,
but if "n6" is not blank, then average "e3:e6"
Let me know if anyone can come up with something.
|