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


"Angelina G" <Angelina wrote in message
...
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.