Excel 2003 - SUM formula

[Chow]

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

Thanks

 

[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?

 

[Sheeloo]

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


in the cell you want the result

 

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

 

[Sheeloo]

=SUM(C1:C100)

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

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]

Max- Thank you so much. It worked great.

Chow

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

 

[Max]

Delighted to hear that. You're welcome.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik