Thread: SumProduct not right
View Single Post
  #4  
Old January 9th, 2010, 02:20 PM posted to microsoft.public.excel.worksheet.functions
Steve
external usenet poster
  
Posts: 2,662
Default SumProduct not right
Nice eyes. That was it.

thanks,

Steve

"Lars-Åke Aspelin" wrote:

On Fri, 8 Jan 2010 13:49:01 -0800, Steve
wrote:

This formula is summing ALL the incidences in the N column of what's in E2. I
want it to sum ONLY those that are in E2 but also also matching what's in A3.

=SUMPRODUCT(--(Data!$E$3:$E$5000=$A$3)--(Data!$R$3:$R$5000=E2),Data!$N$3:$N$5000)

I can't figure out why it's not working, because a similiar formula works
for other situations.

Thanks,

Steve

It seems you have forgotten a comma. Try this:

=SUMPRODUCT(--(Data!$E$3:$E$5000=$A$3),--(Data!$R$3:$R$5000=E2),Data!$N$3:$N$5000)

Hope this helps / Lars-Åke

.