C
Chow
How do I sum that have values from a MULTIPLY formula.
Thanks
Thanks
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sheeloo
Do you want to sum the multiplication of values in two columns? i.e. multiply
values in A1 with B1, A2 with B2 .. and sum the result?
Use
=SUMPRODUCT(A1:A100,B1:B100)
values in A1 with B1, A2 with B2 .. and sum the result?
Use
=SUMPRODUCT(A1:A100,B1:B100)
C
Chow
I have (A1*B1) value in column cell C1=500 and (A2*B2) value in column cell
C2=300. How can i sum C1 and C5 to get value is 800? what formula i should
use?
C2=300. How can i sum C1 and C5 to get value is 800? what formula i should
use?
C
Chow
I have (A1*B1) value in column cell C1=500 and (A2*B2) value in column cell
C2=300. How can i sum C1 and C5 to get value is 800? what formula i should
use?
C2=300. How can i sum C1 and C5 to get value is 800? what formula i should
use?
S
Sheeloo
=C1 + C2
or
=C1 + C5
depending on what you want
in the cell you want the result
or
=C1 + C5
depending on what you want
in the cell you want the result
S
Sheeloo
=C1 + C2
or
=C1 + C5
depending on what you want
in the cell you want the result
or
=C1 + C5
depending on what you want
in the cell you want the result
C
Chow
=C1 + C2 it worked fine for me, but when i sum =C1 : C100 it didn't work
because i have 100 rows and they all have value formula.
because i have 100 rows and they all have value formula.
C
Chow
=C1 + C2 it worked fine for me, but when i sum =C1 : C100 it didn't work
because i have 100 rows and they all have value formula.
because i have 100 rows and they all have value formula.
S
Sheeloo
=SUM(C1:C100)
Chow said:=C1 + C2 it worked fine for me, but when i sum =C1 : C100 it didn't work
because i have 100 rows and they all have value formula.
S
Sheeloo
=SUM(C1:C100)
Chow said:=C1 + C2 it worked fine for me, but when i sum =C1 : C100 it didn't work
because i have 100 rows and they all have value formula.
M
Max
Try something like this which will ignore possible errors or text within the
sum range C1:C100. Array-enter, ie confirm the formula by pressing
CTRL+SHIFT+ENTER (instead of just ENTER):
=SUM(IF(ISNUMBER(C1:C100),C1:C100))
Celebrate success? Click the YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
sum range C1:C100. Array-enter, ie confirm the formula by pressing
CTRL+SHIFT+ENTER (instead of just ENTER):
=SUM(IF(ISNUMBER(C1:C100),C1:C100))
Celebrate success? Click the YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
M
Max
Try something like this which will ignore possible errors or text within the
sum range C1:C100. Array-enter, ie confirm the formula by pressing
CTRL+SHIFT+ENTER (instead of just ENTER):
=SUM(IF(ISNUMBER(C1:C100),C1:C100))
Celebrate success? Click the YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
sum range C1:C100. Array-enter, ie confirm the formula by pressing
CTRL+SHIFT+ENTER (instead of just ENTER):
=SUM(IF(ISNUMBER(C1:C100),C1:C100))
Celebrate success? Click the YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
C
Chow
Max- Thank you so much. It worked great.
Chow
Chow
Max said:Try something like this which will ignore possible errors or text within the
sum range C1:C100. Array-enter, ie confirm the formula by pressing
CTRL+SHIFT+ENTER (instead of just ENTER):
=SUM(IF(ISNUMBER(C1:C100),C1:C100))
Celebrate success? Click the YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
C
Chow
Max- Thank you so much. It worked great.
Chow
Chow
Max said:Try something like this which will ignore possible errors or text within the
sum range C1:C100. Array-enter, ie confirm the formula by pressing
CTRL+SHIFT+ENTER (instead of just ENTER):
=SUM(IF(ISNUMBER(C1:C100),C1:C100))
Celebrate success? Click the YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
M
Max
Delighted to hear that. You're welcome.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
M
Max
Delighted to hear that. You're welcome.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.