CODEWITHSUNDEEP
excelvba
zhuanzhou
zhuanzhou

Reputation: 2453

how to to sum each rows in excel?

how to make the formula effect on the whole sheet.

the format is : get each lines number sum. then substract some numbers.

eg: there are 100 lines records. how to make the formula effects on each lines?

namely : A1+B1+C1+D1+....equals a number, then using the number-20 -15....

each line using the same way, thank you.

Upvotes: 5

Views: 56194

Answers (2)

seriouslee
seriouslee

Reputation: 21

Drag the sum down in corner of cell where cursor becomes + sign

Upvotes: 2

Jacob
Jacob

Reputation: 43309

You can input a range into =SUM() like this:

=SUM(A1:X1)

This calculates the sum of the 1. line from A to X. Just copy/paste the formula to ther rows to calculate the some for those.

Upvotes: 9

Related Questions