I need help with a formula please:
I need to average cells if others contains date
ex: b4 , f4, g4 has date, then I need to average b5,f5,g5.
b5,f5,g5 contains percentages. if there is no date it contains 0 and I do not need to include if there is no date.
Thanks in advance!
I need to average cells if others contains date
ex: b4 , f4, g4 has date, then I need to average b5,f5,g5.
b5,f5,g5 contains percentages. if there is no date it contains 0 and I do not need to include if there is no date.
Thanks in advance!