Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Add cells
Hello,
I have a column (A) with a price from row 1 to 100. I would like to create in column B a formula that will add the total in each row. Example B2 will have the total of A1+A2, - B3 will have the total of A1+A2+A3 - B4 will have the total of A1+A2+A3+A4 and so on till 100. Thank you -- smile |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Add cells
=$a$1:a1
and copy down -- Don Guillett Microsoft MVP Excel SalesAid Software "israel" wrote in message ... Hello, I have a column (A) with a price from row 1 to 100. I would like to create in column B a formula that will add the total in each row. Example B2 will have the total of A1+A2, - B3 will have the total of A1+A2+A3 - B4 will have the total of A1+A2+A3+A4 and so on till 100. Thank you -- smile |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Add cells
"Don Guillett" wrote in message ... "israel" wrote in message ... Hello, I have a column (A) with a price from row 1 to 100. I would like to create in column B a formula that will add the total in each row. Example B2 will have the total of A1+A2, - B3 will have the total of A1+A2+A3 - B4 will have the total of A1+A2+A3+A4 and so on till 100. Thank you -- smile =$a$1:a1 and copy down -- Don Guillett Microsoft MVP Excel SalesAid Software Shouldn't there be a "SUM" in it there somewhere? As in: =SUM( $a$1:a1) and copy down. Or have I misunderstood the OP's problem? -- DB. (a *very* new user of Excel!). |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Add cells
sure should be!!!
-- Don Guillett Microsoft MVP Excel SalesAid Software "DB." wrote in message ... "Don Guillett" wrote in message ... "israel" wrote in message ... Hello, I have a column (A) with a price from row 1 to 100. I would like to create in column B a formula that will add the total in each row. Example B2 will have the total of A1+A2, - B3 will have the total of A1+A2+A3 - B4 will have the total of A1+A2+A3+A4 and so on till 100. Thank you -- smile =$a$1:a1 and copy down -- Don Guillett Microsoft MVP Excel SalesAid Software Shouldn't there be a "SUM" in it there somewhere? As in: =SUM( $a$1:a1) and copy down. Or have I misunderstood the OP's problem? -- DB. (a *very* new user of Excel!). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions |