SUMPRODUCT

ColleenK · Aug 28, 2009

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))

Sean Timmons · Aug 28, 2009

all ranges must be of the same size. Can't have:

$B$70:$B$3003

get rid of that second 3.

Sean Timmons · Aug 28, 2009

oh, and add another - to the second criterion.

ColleenK · Aug 28, 2009

Thank you so much, that fixed it!
--
CK

Sean Timmons said:
oh, and add another - to the second criterion.

Sean Timmons · Aug 28, 2009

You were most of the way there already. :-)

ColleenK said:
Thank you so much, that fixed it!