RE: Logical Function
- From: "brandyda" <brandyda@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 2 Jun 2005 09:19:11 -0700
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
.
- References:
- Logical Function
- From: brandyda
- RE: Logical Function
- From: Peo Sjoblom
- Logical Function
- Prev by Date: Re: Reference to another worksheet
- Next by Date: RE: SumIF Formula
- Previous by thread: RE: Logical Function
- Next by thread: Time Value of Money
- Index(es):
Relevant Pages
|
