Complex Counter

[Vic]

I need a counter in H2 that counts the following:
If J2 > 10/27/2009 then add 17 to H2,
Add 10 to H2 for every cell from M2 thru AS2 that is greater than 10/27/2009,
If AU2 > 10/27/2009 then add 11 to H2,
Add 1 to H2 for every cell from AV2 thru CA2 that is greater than 10/27/2009,
If CC2 > 10/27/2009 then add 10 to H2.
I will need to copy the formula in H2 down to H521.
Thank you.

 

[Luke M]

Assuming the date of 10/27/2009 is in a cell somewhere, say A1:
=17*(J2>$A$1)+10*COUNTIF(M2:AS2,">"&$A$1)+11*(AU2>$A$1)+1*COUNTIF(AV2:CA2,">"&$A$1)+10*(CC2>$A$1)

Note how the constants are multiplied against the various arguements to
produce your total.