How can I write an "If" Statement to perform a calculation if a Cell contains a specificed value?

[keithsaun]

I'd like to have Excel look at a Cell, and IF it contains a specified value to perform a calculation on a range of cells meeting.

For Example:
Data Range is A1:K527
Cell B1 contains the value for the month "January"
Cell C1 contains the value for the number of Employees "2.0"

I'd like to see a formula that says something like, "If the value of B1="January", then provide the Average of the Range of C1:C527.

Is this possible?

 

[Joe4]

Welcome to the Board!

Try:

=IF(B1="January",AVERAGE(C1:C527),"")