How do I sum that have values from a MULTIPLY formula.

Thanks

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)
"Chow" wrote:

How do I sum that have values from a MULTIPLY formula.

Thanks

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?

"Sheeloo" wrote:

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)
"Chow" wrote:

How do I sum that have values from a MULTIPLY formula.

Thanks

=C1 + C2
or
=C1 + C5
depending on what you want


in the cell you want the result

"Chow" wrote:

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?

"Sheeloo" wrote:

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)
"Chow" wrote:

How do I sum that have values from a MULTIPLY formula.

Thanks

=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.

"Sheeloo" wrote:


=C1 + C2
or
=C1 + C5
depending on what you want


in the cell you want the result

"Chow" wrote:

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?

"Sheeloo" wrote:

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)
"Chow" wrote:

How do I sum that have values from a MULTIPLY formula.

Thanks

=SUM(C1:C100)

"Chow" wrote:

=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.

"Sheeloo" wrote:


=C1 + C2
or
=C1 + C5
depending on what you want


in the cell you want the result

"Chow" wrote:

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?

"Sheeloo" wrote:

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)
"Chow" wrote:

How do I sum that have values from a MULTIPLY formula.

Thanks

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
---
"Chow" wrote:
=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.

Max- Thank you so much. It worked great.

Chow

"Max" wrote:

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
---
"Chow" wrote:
=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.

Delighted to hear that. You're welcome.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Chow" wrote in message
...
Max- Thank you so much. It worked great.