how do i add multiple cell in the same row then multiply the value

G

Global

hi,
here is what i am trying to do. i would like to add the following:

in A21 i need to do these calculations below.

Add A1 to A20.
after that i need to multiple the total by by 0.07 in the same cell that
being in A21
Can someone help me with the formula please?
 
D

Duane Hookom

You might want to take this question to an Excel news group. You might find a
reply like
=Sum(A1..A20) * 0.07
 
L

lizhiyi

Global said:
hi,
here is what i am trying to do. i would like to add the following:

in A21 i need to do these calculations below.

Add A1 to A20.
after that i need to multiple the total by by 0.07 in the same cell that
being in A21
Can someone help me with the formula please?
Click to expand...
 
Top