Sumproduct Question

[hansjhamm]

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

 

[Don Guillett]

spacing perhaps

 

[via135]

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

-via13

 

[hansjhamm]

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

 

[Don Guillett]

You could use trim in some fashion

 

[hansjhamm]

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


Hans