| 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... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to total rows in Excel with non-value cells like "included"?
=sum(if(D5="included",0,D5)*4)+if(B55 = "included",0,B55)
HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "HR" wrote: 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... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to total rows in Excel with non-value cells like "included
Thanks so much - it works perfectly now!!
"Gary L Brown" wrote: =sum(if(D5="included",0,D5)*4)+if(B55 = "included",0,B55) HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "HR" wrote: 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... |
| Reply |
| 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) | |||
Linear Mode
