formula suggestion please

A

Anthony

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
 
B

Bob Phillips

=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)
 
A

Anthony

thanks Bob

Bob Phillips said:
=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)
Click to expand...
 
Top