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

A

Angelina G

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.
 
E

Excelenator

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?
 
B

Bernie Deitrick

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
 
T

tim m

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?
 
A

Angelina G

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.
 
A

Angelina G

Angelina G said:
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 [ACROSS] that row and sums it all up at
the end of that row.

tim m said:
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?
Click to expand...
Click to expand...
 
Top