Log In
Register
Home
Active Member
November 18, 2019
Offline
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?
See Answer
July 16, 2010
Offline
Hi Eithan,
I think what you're describing is the SUMPRODUCT function e.g.
=SUMPRODUCT(A1:A50,B1:B50*(C1:C50=100))
Mynda
Active Member
November 18, 2019
Offline
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
July 16, 2010
Offline
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.
Active Member
November 18, 2019
Offline
Hey!
I want it to sum G*E only if their D=BP.TF➤MP.TF
Trusted Members
Moderators
November 1, 2018
Offline
This should work:
=SUMPRODUCT(--($D$3:$D$88="BP.TF➤MP.TF"),$G$3:$G$88,$E$3:$E$88)
Answers Post
Active Member
November 18, 2019
Offline
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
VIP
Trusted Members
December 7, 2016
Offline
Hello,
If you haven’t already, do consider taking this course.
Just remove the quotation marks surrounding the.number. =IF(C95<>"",1,"")
1 Guest(s)
