![]() |
$ 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. |
$ 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