Excel Calculation? 2

[Yerdon]

Hi everyone,

I have the following columns and cells.

A   B   C   D   E   F   G   H   I   J
-------------------------------------
3   2   3   4   1   3   1   4   2   3

Then, I have a "master" cell which contains a value from A to J. Based on the contents of that cell, I would sum all columns up until that one. For example:

Master = C, then Total value = 8
Master = E, then Total Value = 13
Master = A, then total value = 3

How can I do such a thing?

Thanks in advance!

Joseph

 

[AnotherHiggins]

Have a look at the INDIRECT function.

In A2, place whatever column header you want.

In an empty cell: [COLOR=blue white]=Sum(Indirect("A1:"&A2&"1"))[/color]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[Yerdon]

Perfect! Thank you!