Here is my formula:
=SUMPRODUCT(--('Call Summary.xls'!$I$10:$I$5000=C78),--('Call
Summary.xls'!$D$10:$D$5000<"lastname, firstname"),--('Call
Summary.xls'!$L$10:$L$5000))

This works fine; but when I change the "lastname, firstname" to this;

=SUMPRODUCT(--('Call Summary.xls'!$I$10:$I$5000=C78),--('Call
Summary.xls'!$D$10:$D$5000<C78),--('Call Summary.xls'!$L$10:$L$5000))

It sums all the data including the data I do not want referenced in
cell C78...


Does anyone know why??


Thanks,

Hans

spacing perhaps

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
Here is my formula:
=SUMPRODUCT(--('Call Summary.xls'!$I$10:$I$5000=C78),--('Call
Summary.xls'!$D$10:$D$5000<"lastname, firstname"),--('Call
Summary.xls'!$L$10:$L$5000))

This works fine; but when I change the "lastname, firstname" to this;

=SUMPRODUCT(--('Call Summary.xls'!$I$10:$I$5000=C78),--('Call
Summary.xls'!$D$10:$D$5000<C78),--('Call Summary.xls'!$L$10:$L$5000))

It sums all the data including the data I do not want referenced in
cell C78...


Does anyone know why??


Thanks,

Hans

hi!

maybe

=SUMPRODUCT(--('Call Summary.xls'!$I$10:$I$5000=C78)*('Call
Summary.xls'!$D$10:$D$5000<C78),('Call Summary.xls'!$L$10:$L$5000))

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=542213

Don,

Thanks...at least you told me that the formula was correct...I copied
and pasted the name from the "summary" and it worked...Who knows!?! an
Excel formatting thing


Hans

You could use trim in some fashion

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
Don,

Thanks...at least you told me that the formula was correct...I copied
and pasted the name from the "summary" and it worked...Who knows!?! an
Excel formatting thing


Hans

Hey Guys....Thanks for all the help it works perfect now!!


Hans