Logical Function

B

brandyda

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.
 
P

Peo Sjoblom

Are the values in T6:T500 text? If not remove the qoutations around 1 in your
criteria

Regards,

Peo Sjoblom
 
Top