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

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.
 
G

Gord Dibben

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

How do I designate dates using info from a cooresponding drop down list? 3
How do I reference a cell as a row number in a formula? 4
Problem with draging a formula,one cell value fixed,trivial question 3
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
Troubleshooting "Fill Down/Right" with a formula 2
How do I drag a hyperlink series to fill instead of copy? 2
V-look up/Auto Sum values only update when saving 1
Auto Sum 8

Top