| 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. |
| 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) | |||
Threaded Mode
