Sumproduct Question

[[email protected]]

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

--
Don Guillett
SalesAid Software
[email protected]
<[email protected]> wrote in message
news:[email protected]...
> 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
>

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

-via135

[[email protected]]

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

--
Don Guillett
SalesAid Software
[email protected]
<[email protected]> wrote in message
news:[email protected]...
> 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
>

[[email protected]]

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


Hans