ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   $ value formulas (https://www.excelbanter.com/excel-worksheet-functions/102509-%24-value-formulas.html)

Angelina G

$ value formulas
 
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.


Miguel Zapico

$ value formulas
 
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.

"Angelina G" wrote:

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.



All times are GMT +1. The time now is 05:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com