How to total rows in Excel with non-value cells like "included"?

[HR]

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...

[Gary L Brown]

=sum(if(D5="included",0,D5)*4)+if(B55 = "included",0,B55)

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
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...

[HR]

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
> gary_brown@ge_NOSPAM.com
> 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...