Excel 2003 - SUM formula
 

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

Thanks

Excel 2003 - SUM formula
 

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

Excel 2003 - SUM formula
 

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

Excel 2003 - SUM formula
 

=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

Excel 2003 - SUM formula
 

=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

Excel 2003 - SUM formula
 

=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

Excel 2003 - SUM formula
 

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.

Excel 2003 - SUM 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.

Excel 2003 - SUM 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.