Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
complex color fill conditions- if statements or complex formula? | Excel Discussion (Misc queries) | |||
1+2+3+4+........... Counter | Excel Discussion (Misc queries) | |||
Complex Index Match Help (or at least complex to me) | Excel Discussion (Misc queries) | |||
Counter | Excel Discussion (Misc queries) | |||
Counter | Excel Discussion (Misc queries) |