formula suggestion please
thanks Bob
"Bob Phillips" wrote:
=SUMPRODUCT((MONTH(B2:B20)=1)*(C2:AG20))
SP cannot work on complete columns, you have to give a defined range
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Anthony" wrote in message
...
Hi
Can anybody give me a formula for this as I can do the basics, but this is
beyond me.
I want to check the month populated in cell A1 then search column B for
that
month and once found give me an average of the corresponding cells C:AG.
Can this be done, if so how??
many thanks
|