Formula for if name begins with and date is less than or equal to.
in [Functions]
|
From: Senor Martinez on 5 Feb 2010 10:58 Im trying to create a formula that gives me a total count for cells that are less than 02/05/10 and the name begins with FHLM, on previous post teethless mama helped me w this, but im still getting a value of 0. Someone please help!! =SUMPRODUCT(--(E1:E100<=DATE(2010,2,5)),--(LEFT(U1:U100,4)="FHLM")) Thanks in advance.
From: Mike H on 5 Feb 2010 11:04 Hi, Your formula works fine for me, what problem are you having? Are you sure the dates are really dates and not text? -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Senor Martinez" wrote: > Im trying to create a formula that gives me a total count for cells that are > less than 02/05/10 and the name begins with FHLM, on previous post teethless > mama helped me w this, but im still getting a value of 0. Someone please > help!! > > =SUMPRODUCT(--(E1:E100<=DATE(2010,2,5)),--(LEFT(U1:U100,4)="FHLM")) > > > Thanks in advance. >
|
Pages: 1 Prev: Nested subtotals in incorrect order on large worksheets Next: Track Changes History Worksheet |