| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total rows w/$, NA, Included
I am trying to calculate a number in a "total" cell, but some of the cells
I'm using in the calculation contain $0.00, "NA", "Included", "TBD". I asked this question before and got an excellent response, but then I only had the words "included". I can't seem to manipulate the formula to work when a row has more than one word (NA, Included, TBD). Here's what I'm using: =sum(if(D5="included",0,D5)*4)+if(B55="included",0 ,B55). I need to modify this so it will work if what's in the "included" part is included, NA, or TBD. Can anyone help me with this!? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| matching the column b(sku)c(count)with A | Excel Worksheet Functions | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
| Subtract several rows from a total | New Users to Excel | |||
| Deleting rows containing common data | Excel Discussion (Misc queries) | |||
Threaded Mode
