$ value formulas

A

Angelina G

I have a spreadsheet which 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.
 
M

Miguel Zapico

One option can be the following:
1.- Add a row with the values you want to add (the $50 for code 359) to the
top of the table (say row 1)
2.- At the end of the row (here I suppose only 5 columns, change as
required) use the following formula:
=SUMIF(A3:E3,"X",$A$1:$E$1)
This will check the row for the values equal to X, and add the values on the
first row for them.

Hope this helps,
Miguel.
 
Top