Complex Counter
 

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.

Complex Counter
 

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.

--
Best Regards,

Luke M
"Vic" wrote in message
...
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.