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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Real-time sorting 11
Using a SUMIF and Parsing to sum part of a cell 6
Variable row number in Sum($A$1:A10) formula 3
a twist to relative ranges 5
Relative reference autofill increment other than +1 3
Help with a simple formula! 8
Problem with draging a formula,one cell value fixed,trivial question 3
Sum of a range that varies 1

Back
Top