0
I used the function "Somarproduto" to add the total of products 1 and 2, but the result of zero, I wanted to add the total values of only two products on the list, but it only works by adding 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)) 
0
SOMARPRODUCT treats non-numerical matrix entries as if they were zeroes. https://support.office.com/pt-br/article/fun%C3%A7%C3%A3o-somarproduto-16753e75-9f68-4874-94ac-4d2145a2fd2e
Your column E "Value R$" is not a numerical value so it is considered 0 and the multiplication result is 0.
Try putting "100.0" instead of "R$ 100.0"
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.
I inserted in number format, but still keeps giving zero, even pressing Ctrl + shift + enter
– Elienay Junior
Would have some way to add up the total of these two products, using only a formula sequence?
– Elienay Junior
Try
=SOMARPRODUTO(A22:A38,E22:E38)keeping the values as number.– Pbras
It was not possible, because it has to specify the criterion being only products 1 and 2, that in the case would give the total sum of them two together
– Elienay Junior
=PRODUCT(A22:A38)+PRODUCT(E22:E38)Try it this way. You don’t want to add up the multiplication values of all the elements of column A and the multiplication of column E?– Pbras
Only those with "Product Code" 1 and 2, only 1 and 2
– Elienay Junior
=SOMARPRODUTO((A4:A20=A4)*(E4:E20))+SOMARPRODUTO((A4:A20=A5)*(E4:E20))or just:=SOMASE(A4:A20;A4;E4:E20)+SOMASE(A4:A20;A5;E4:E20)– Elienay Junior
I could not with subtraction, multiplication and division, only with sum, if it had subse, multse, divide, would be right as in the sum
– Elienay Junior
Sorry for the delay. You want the sum of the values of everyone in the column that has the product code=1 or 2?
– Pbras
Yes, but I have already managed here, to make the sum and also to multiply only the specific products. Now I intend to do the subtraction and division, but so far I haven’t found a way
– Elienay Junior
I’m going to post another question, now how to do the subtraction and division
– Elienay Junior