Hey!! I would like some help formatting a formula that will sum a1:a50*b1:b50 for example but only if c1=1 (for example)
If c1=100 so it would sum a2:a50*b2:b50.
does anyone knows how to fix it?
Hi Eithan,
I think what you're describing is the SUMPRODUCT function e.g.
=SUMPRODUCT(A1:A50,B1:B50*(C1:C50=100))
Mynda
Hey, I need it to sum it when c1=text if it won't it won't sum raw 1, and then it will check if raw 2 has text in c2 and if it do so a2*b2
I could send the file if it would be more helpfull
Yes, please send the file including example of every scenario. Please also be clear whether C1=text, if text is the word "text", any text, any cell that's not empty. In your sample file include examples of the desired result, so we can check our results match what you're expecting.
Hey!
I want it to sum G*E only if their D=BP.TF➤MP.TF
This should work:
=SUMPRODUCT(--($D$3:$D$88="BP.TF➤MP.TF"),$G$3:$G$88,$E$3:$E$88)
Hello!
The formula Velouria gave me works except when this formula {=IF(C95<>"","1","")} correct and the answer is "1" it wont calculate it, does anyone has an idea how to fix this?, you have the file attached in my previous comment.
Thanks
Hello,
If you haven’t already, do consider taking this course.
Just remove the quotation marks surrounding the.number. =IF(C95<>"",1,"")
