formula suggestion please
 

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

formula suggestion please
 

=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

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