From: Senor Martinez on
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
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.
>