how do I sum fields down through a fixed field value.

  • Thread starter Thread starter rgisla
  • Start date Start date
R

rgisla

Hey, I am trying to fill fields down by auto sum fields down. Ie. selecting
A10 through 20 where I am inserting value from cell B10. What happens when I
auto sum is that it calculates each field down, i.e. A10, A11 and so on.
 
What do you mean by "auto sum fields down"?

And "inserting value from B10"

You want to add the value of B10 to each of A10:A20?

Copy B10, select A10:A20 and paste special>add>ok>esc.


Gord Dibben MS Excel MVP
 
Back
Top