Complex Counter
in [General]
|
From: Vic on 17 May 2010 10:02 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.
From: Luke M on 17 May 2010 11:01 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" <Vic(a)discussions.microsoft.com> wrote in message news:AD07D4E6-3E95-4683-B203-296486D4F277(a)microsoft.com... >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.
|
Pages: 1 Prev: Matching two groups of data within one sheet Next: Excel Drop Down Box |