sumproduct returns "Value"need help. Thank you

[Eduardo]

Hi to everybody, I hope somebody can help me. I have three columns as follow

adam DAP $4,350.00
adam DAP $6,730.77
adam DAP $48,076.93
adam DAP $5,192.31
adam Maintenance/TSA $2,225.00
adam Maintenance/TSA $1,375.00
adam Maintenance/TSA $1,312.50
adam Maintenance/TSA $5,048.20
adam Product $1,250.00
adam Product $5,048.07

and I need to summarize the above information as follow
Adam

DPA
Maintenance
Product
I tried the formula as follow but I cannot figure out what is wrong
=+SUMPRODUCT(--(K8:K507=P9),--(J8:J506=Q6),--(L8:L510))

Column K is where I have DAP, Maintenance, Products and column J is where I
keep the different names
Thank you for any help

 

[Domenic]

The ranges need to be the same size...

=SUMPRODUCT(--(K8:K510=P9),--(J8:J510=Q6),L8:L510)

Hope this helps!

 

[Stefi]

=SUMPRODUCT(--(K8:K507=P9),--(J8:J507=Q6),--(L8:L507))

Ranges in SUMPRODUCT must be of equal length!

Regards,
Stefi

„Eduardo†ezt írta:

 

[Eduardo]

Hi Stefi, thank you so much, I didn't know the range has to be the same,
thank you again

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„Eduardo†ezt írta: