Hi There,

Can anyone tell me why I am getting #Value! error with the following formula;

=SUMPRODUCT(--(DATASHEET!$B$70:$B$300=C87),-(DATASHEET!$B$70:$B$3003<""),(DATASHEET!$E$70:$E$ 300))
--
CK