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

H

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

HR

Thanks so much - it works perfectly now!!

Gary L Brown said:
=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?''.
Click to expand...
 
Top