| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add a column of cells, but IF a row has (), subtract?
I have a column (G) of rows from 1 to 6. I want to add that column,
however, sometimes one of the rows may have a number I need subtracted. How can I come up with a 'hopefully' short formula to determine IF there is () in any row of that column, to subtract it. Such as: row1: 8:00 row2: 6:00 row3: 3:00 row4: (9:00) row5: 5:00 row6: (7:30) should equal 5:30 But another time it might be row2 with the () or row 3 and 5. Or should I use - instead of ()? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Macro Help: Concatenate Populated Cells in Column A | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| how can i fill blank cells in column with abc while the right col. | Excel Discussion (Misc queries) | |||
Threaded Mode
