Total rows w/$, NA, Included

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

[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

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

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

"HR" wrote:

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