Logical Function
 

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

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

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