sumproduct returns "Value"need help. Thank you
You are welcome! Thanks for the feedback!
Stefi
€˛Eduardo€¯ ezt Ć*rta:
Hi Stefi, thank you so much, I didn't know the range has to be the same,
thank you again
"Stefi" wrote:
=SUMPRODUCT(--(K8:K507=P9),--(J8:J507=Q6),--(L8:L507))
Ranges in SUMPRODUCT must be of equal length!
Regards,
Stefi
€˛Eduardo€¯ ezt Ć*rta:
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
|