I used the "Add product" function to add the total of products 1 and 2, but the result of zero, I wanted to sum the total of the values of only two products in the list, but only works by adding only one, as I do to apply the sum only in products 1 and 2 ?? =SOMARPRODUTO((A22:A38=A22)*(E22:E38)*(A22:A38=A23)*(E22:E38)) 
Excel "Add-on" function, does not add the total of two distinct items in relation to the list?
0
asked by anonymous 26.10.2018 / 17:55
1 answer
0
SOMARPRODUCT treats non-numeric matrix entries as if they were zeros. link
Your column E "Value R $" is not a numerical value so it is considered 0 and the multiplication result is 0.
Try to enter "100.0" instead of "$ 100.0"
26.10.2018 / 18:05