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