If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|