RE: Logical Function

T is a number as text
E is an age developed by a formula
F is text
G is text
--
B. Davis


"Peo Sjoblom" wrote:

> Are the values in T6:T500 text? If not remove the qoutations around 1 in your
> criteria
>
> Regards,
>
> Peo Sjoblom
>
> "brandyda" wrote:
>
> > Can anyone tell me what is wrong with this function? I've switched from
> > Excel 2000 to 2003. - it used to work, but doesn't now.
> >
> > =SUMPRODUCT(--(E6:E500=W24),(--(T6:T500="1")))
> >
> > Trying to calculate how many have two existing conditions ALSO how many if
> > there are three existing conditions.
> >
> >
> > --
> > B. Davis
.