software

I am trying to calculate a number using =sum(D5*4) B55, but one of the cells
contains the the word quot;includedquot;. 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...

=sum(if(D5=quot;includedquot;,0,D5)*4) if(B55 = quot;includedquot;,0,B55)

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;HRquot; wrote:

gt; I am trying to calculate a number using =sum(D5*4) B55, but one of the cells
gt; contains the the word quot;includedquot;. It's a pricing model, so it's important to
gt; note in a cell that something is included vs. $0 cost. When I add am just
gt; adding, =sum(B5:B12), it works fine, but not when I use the multiplier. It
gt; seems like this must be a simple solution, but I can't come up with it...

Thanks so much - it works perfectly now!!

quot;Gary L Brownquot; wrote:

gt; =sum(if(D5=quot;includedquot;,0,D5)*4) if(B55 = quot;includedquot;,0,B55)
gt;
gt; HTH,
gt; --
gt; Gary Brown
gt;
gt; If this post was helpful, please click the ''Yes'' button next to ''Was this
gt; Post Helpfull to you?''.
gt;
gt;
gt; quot;HRquot; wrote:
gt;
gt; gt; I am trying to calculate a number using =sum(D5*4) B55, but one of the cells
gt; gt; contains the the word quot;includedquot;. It's a pricing model, so it's important to
gt; gt; note in a cell that something is included vs. $0 cost. When I add am just
gt; gt; adding, =sum(B5:B12), it works fine, but not when I use the multiplier. It
gt; gt; seems like this must be a simple solution, but I can't come up with it...