# List cumulative values in a column

1. ## List cumulative values in a column

I have in two columns the following:
week1 5
week2 9
week3 7

These weeks start with zero data in it originally. Then I input my total
for week1 in column AD6 and want that total number to show up in column B1.
Then, the next week, I enter 9 in week2, and want that number to show up in
column B1.,etc.

How do I get excel to I guess look at the range of AD6 through AD19 and as I
enter in my week total, it's captured/displayed in column B1.
I tried the MAX function which works, but when my week3 data is less than
week2 it will not show my week3 value in column B1.

Any help would be greatly appreciated.

2. ## Re: List cumulative values in a column

Hi!

Try one of these formulas in cell B1:

Biff

"danie" <danie@discussions.microsoft.com> wrote in message
news:7A12EC31-39AF-40D9-A4EE-296E64D912B1@microsoft.com...
>I have in two columns the following:
> week1 5
> week2 9
> week3 7
>
> These weeks start with zero data in it originally. Then I input my total
> for week1 in column AD6 and want that total number to show up in column
> B1.
> Then, the next week, I enter 9 in week2, and want that number to show up
> in
> column B1.,etc.
>
> How do I get excel to I guess look at the range of AD6 through AD19 and as
> I
> enter in my week total, it's captured/displayed in column B1.
> I tried the MAX function which works, but when my week3 data is less than
> week2 it will not show my week3 value in column B1.
>
> Any help would be greatly appreciated.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1