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.