Total rows w/$, NA, Included

H

HR

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!?
 
M

mr_teacher

Hi,
Not an expert in these matters but I think I had a similar problem to
yourself and solved it using this formula

=sum(if(or(d5="included",d5="NA",d5="TBD"),0,d5)*4)+if(or(b55="included",b55="NA",b55="TBD"),0,B55)

You can add as many words as you like within the OR pattern, just keep
on following the same design.

Hope that is of some help - or at least not messed you up even more!1
:)

Regards

Carl
 
H

HR

Thank you so much! That worked! These formulas are so picky - I tried this
a number of ways, but didn't include the (or( after the IF! Thanks again.
 
Top