Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
run total in excel
Iis there a formula that will keep a running total in excel
example: C2=5 B2=5 total in A2 =10 now if I change C2 to 8 then A2 will be 18 and if I change B2 to 12 then A2 will = 30 I dont want to use VBA if at all possible -- grizz |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
run total in excel
Hi Grizzly
In A2 type =c2+b2 Any number you will type in C2 & b2 will be added to A2 Regards John "grizzly6969" wrote in message ... Iis there a formula that will keep a running total in excel example: C2=5 B2=5 total in A2 =10 now if I change C2 to 8 then A2 will be 18 and if I change B2 to 12 then A2 will = 30 I dont want to use VBA if at all possible -- grizz |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
run total in excel
Thanks John but this will not keep a running total. - this will only add the
two numbers put in B2 and C2 together -- grizz "grizzly6969" wrote: Iis there a formula that will keep a running total in excel example: C2=5 B2=5 total in A2 =10 now if I change C2 to 8 then A2 will be 18 and if I change B2 to 12 then A2 will = 30 I dont want to use VBA if at all possible -- grizz |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
run total in excel
Hi Grizzly
Sorry but I would need more information to help you.But take a look at this site, its small videos on excel basic functions. They are short and very good, this may help you. Regards John http://www.youtube.com/results?searc...h_t ype=&aq=f "grizzly6969" wrote in message ... Thanks John but this will not keep a running total. - this will only add the two numbers put in B2 and C2 together -- grizz "grizzly6969" wrote: Iis there a formula that will keep a running total in excel example: C2=5 B2=5 total in A2 =10 now if I change C2 to 8 then A2 will be 18 and if I change B2 to 12 then A2 will = 30 I dont want to use VBA if at all possible -- grizz |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
run total in excel
I'm not sure if this is what you're looking for but . . .
Assume your numbers are in column A starting with A1. In B1 put =A1. Then in B2 put =B1+A2 and copy that down as far as you need in B. The end result will look sort of like: 4 4 5 9 5 14 6 20 7 27 "grizzly6969" wrote: Thanks John but this will not keep a running total. - this will only add the two numbers put in B2 and C2 together -- grizz "grizzly6969" wrote: Iis there a formula that will keep a running total in excel example: C2=5 B2=5 total in A2 =10 now if I change C2 to 8 then A2 will be 18 and if I change B2 to 12 then A2 will = 30 I dont want to use VBA if at all possible -- grizz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
Total column changes colors when total equals sum of other columns | New Users to Excel | |||
Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |