| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to total rows in Excel with non-value cells like "included"?
I am trying to calculate a number using =sum(D5*4)+B55, but one of the cells
contains the the word "included". It's a pricing model, so it's important to note in a cell that something is included vs. $0 cost. When I add am just adding, =sum(B5:B12), it works fine, but not when I use the multiplier. It seems like this must be a simple solution, but I can't come up with it... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| I want to sort selected cells in Excel, not entire rows. | Excel Discussion (Misc queries) | |||
Threaded Mode
