Average based on the previous row
Thanks a lot all of you.
:)
"Roger Govier" wrote in message
...
Hi Gary
One way
=SUMPRODUCT((MONTH(B2:AF2)=1)*(B2:AF2<"")*B3:AF3)/
SUMPRODUCT((MONTH(B2:AF2)=1)*(B2:AF<""))
--
Regards
Roger Govier
"Gary" wrote in message
...
Hi All,
in row 2 I have dates jan 1 to jun 31
in row 3 I have some data.
now if in cell A60 i need the average of the data in row 3 only for
January....so if Jan starts in cell B2 and ends in cell AF2, I need the
average of data in B3 to AF3
please help.
Thanks
|