=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