How do I give different $ value to different colums in Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angelina G - 28 Jul 2006 14:37 GMT

I have a spreadsheet that has 51 columns across and 12 rows down. I am
trying to give each column (down) a different money value, so when I mark
that column (x) with other columns in that same row it can automatically add
up at the end of each column.

Reply to this Message

Excelenator - 28 Jul 2006 15:33 GMT

what are you trying to add? What is contained in the table you
describe? Where do you want the totals to appear? What $ values do
you want to assign?

Signature

Excelenator

Reply to this Message

Bernie Deitrick - 28 Jul 2006 15:37 GMT

Put your dollar values for each column in row 1, then use a formula like this in cell BA2

=SUMPRODUCT((B2:AZ2="x")*$B$1:$AZ$1)

or maybe you mean this, in cell B14

=COUNTIF(B2:B13,"x")*B$1

to sum when the column has an x in it. Copy down to match your rows, or across to match your
columns.....

HTH,
Bernie
MS Excel MVP

>I have a spreadsheet that has 51 columns across and 12 rows down. I am
> trying to give each column (down) a different money value, so when I mark
> that column (x) with other columns in that same row it can automatically add
> up at the end of each column.

Reply to this Message

tim m - 28 Jul 2006 15:57 GMT

Can you explain futher, it's not clear (at least not to me) what you want to
accomplish.

Perhaps give us some example of your data?

> I have a spreadsheet that has 51 columns across and 12 rows down. I am
> trying to give each column (down) a different money value, so when I mark
> that column (x) with other columns in that same row it can automatically add
> up at the end of each column.

Reply to this Message

Angelina G - 31 Jul 2006 12:59 GMT

This spreadsheet has different codes of my job across (top row), I mark with
an X which of these codes I have done for each job. I want to be able, if
possible, when I mark let's say an X on code 359 the worksheet recognizes it
as $50 together with whatever else I mark down that row and sums it all up at
the end of that row.

> Can you explain futher, it's not clear (at least not to me) what you want to
> accomplish.
[quoted text clipped - 5 lines]
> > that column (x) with other columns in that same row it can automatically add
> > up at the end of each column.

Reply to this Message

Angelina G - 31 Jul 2006 14:34 GMT

> This spreadsheet has different codes of my job across (top row), I mark with
> an X which of these codes I have done for each job. I want to be able, if
[quoted text clipped - 11 lines]
> > > that column (x) with other columns in that same row it can automatically add
> > > up at the end of each column.

Reply to this Message