Prev: Sorting Data
Next: code problem not working HELP
From: Michael Koerner on 30 Oct 2009 16:15
I would like to put the cost of an item in a cell and have the sum of the
costs in a cell to the right but at the top of the column I would like to
have a total item count for all the items in that column would look
something like this, with Col A items worth $15.00, Col B $10.00 and so on.

A B C D E F G
3 1 5
1 15.00 10.00 20.00 $55.00
2 20.00 $20.00
3 30.00 20.00 $30.00
4 20.00 $20.00
5 20.00 $20.00

Help as always, is greatly appreciated.

--

Regards
Michael Koerner



From: smartin on 30 Oct 2009 19:29
Michael Koerner wrote:
> I would like to put the cost of an item in a cell and have the sum of the
> costs in a cell to the right but at the top of the column I would like to
> have a total item count for all the items in that column would look
> something like this, with Col A items worth $15.00, Col B $10.00 and so on.
>
> A B C D E F G
> 3 1 5
> 1 15.00 10.00 20.00 $55.00
> 2 20.00 $20.00
> 3 30.00 20.00 $30.00
> 4 20.00 $20.00
> 5 20.00 $20.00
>
> Help as always, is greatly appreciated.

If I read you right, something like this?

A
1 =SUM(A2:A6)/15
2 15.00
3
4 30.00
5
6

From: Michael Koerner on 31 Oct 2009 05:16
Arrrrrrrrgh! I came up with the same solution at 03:00 am this morning. You
don't want to know how may days I have been thinking about this thing.
thanks for confirming.

--

Regards
Michael Koerner


"smartin" <smartin108(a)gmail.com> wrote in message
news:3didnbxEcYdI63bXnZ2dnUVZ_tKdnZ2d(a)giganews.com...
Michael Koerner wrote:
> I would like to put the cost of an item in a cell and have the sum of the
> costs in a cell to the right but at the top of the column I would like to
> have a total item count for all the items in that column would look
> something like this, with Col A items worth $15.00, Col B $10.00 and so
> on.
>
> A B C D E F G
> 3 1 5
> 1 15.00 10.00 20.00 $55.00
> 2 20.00 $20.00
> 3 30.00 20.00 $30.00
> 4 20.00 $20.00
> 5 20.00 $20.00
>
> Help as always, is greatly appreciated.

If I read you right, something like this?

A
1 =SUM(A2:A6)/15
2 15.00
3
4 30.00
5
6


 | 
Pages: 1
Prev: Sorting Data
Next: code problem not working HELP