The ranges need to be the same size...

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

Hope this helps!

In article ,
Eduardo wrote:

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