Sumproduct Question
 

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

Sumproduct Question
 

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

Sumproduct Question
 

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

Sumproduct Question
 

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

Sumproduct Question
 

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

Sumproduct Question
 

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


Hans