
Active Member

November 18, 2019

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?


July 16, 2010

Hi Eithan,
I think what you're describing is the SUMPRODUCT function e.g.
=SUMPRODUCT(A1:A50,B1:B50*(C1:C50=100))
Mynda


July 16, 2010

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.


Trusted Members
Moderators

November 1, 2018


VIP

Trusted Members

December 7, 2016

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)
