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.