count if doubling results

[Linsie]

Hi,

It may be the time of night, but i can't for the life of me figure out how to stop my formula from doubling some results.

The formula i am using is
=COUNTIF(W251:W273,"*O*")+COUNTIF(W251:W273,"*+*")

The formula is to count how many overtime shifts are being worked that day.

The cell will be contents can be
M+
A+
N+
MO+
AO+
NO+

All of these entries should only be counted once. However the cells that has the O and the + in them are being counted twice.

Can anyone please save my very tired brain and suggest how to resolve it?

Thanks in advance.

 

[mikerickson]

=countif(w251:w273,"*o*")+countif(w251:w273,"*+*")-countif(w251:w273, "*o*+*")-countif(w251:w273, "*+*o*")

 

[Scott Huish]

I may be missing something, but it seems that everything your counting depends on it having a +, whether or not there is an O with it, so couldn't you just count for that?

=COUNTIF(W251:W256,"*+*")

 

[Linsie]

You know Scott, I have looked at this report for the last 8 hours working on it and setting it up, and i didn't even realize that. Thank you for pointing it out. Problem now solved!