Formula to add/subtract text characters in a row.

[aacod]

In row D28:AH28 in majority of the cells, I have X, L, TW, H and PV. Few cells do not have anything, just blank.

I need a formula to add cells which contain X, TW and subtract from that total cells containing L, H, PV and blank cells.

Thanks.

aacod.

 

[JoeMo]

=countif(d28:ah28,"x")+countif(d28:ah28,"tw")-countif(d28:ah28,"l")-countif(d28:ah28,"h")-countif(d28:ah28,"pv")-countif(d28:ah28,"")

 

[aacod]

JoeMo,

The formula works perfect for the above description, but sorry for not describing perfectly what I wanted to accomplish.

I am trying to count a total of 'X' and 'TW', 'C, and 'CWS' from 30 to 31 cells each representing the day of the month and not count the 'L', 'H', 'PV' 'W' and blank cell(s).

Please see example below:

x

x

TW

x

L

W

W

x

x

TW

x

L

W

W

x

x

TW

x

L

W

W

x

x

TW

x

L

W

W

x

x

=18

<colgroup><col span="18" width="22"><col span="13" width="22"><col width="54"></colgroup><tbody>
</tbody>

Thanks.

aacod