Hi!

I'll start off saying that I use excel just for the basics and don't have a
strong background in it. Here is my problem. I use a spreadsheet to put our
Dept schedule on and I need it to count the number of people for each part of
the shift, so we know that we have appropriate coverage.

So far, I have 3 rows counting the following
Row 1 - counts the night shift person staying 1st 1/2 of days
Row 2 - counts actual Day shift staff
Row 3 - counts the PM shift person coming in for 2nd 1/2 of days

I use the following text for each person, depending on shift and length of
shift (I work in Health Care)

N 10 Stays till 0900 on the day shift
D Day shift staff (0630 - 1530)
D 12 Stays till 1900
S 12 Comes in at 1030 on the day shift
S PM shift staff (1430 - 2300)
N 12 Comes in at 1830 on the PM shift
N Night shift staff (2230 0 0700)


The formulas I have are as follows i.e. 1st column
=COUNTIF(B7:B61,"*N10*")
=COUNTIF(B7:B61,"*D*")
=COUNTIF(B7:B61,"*S 12*")

This works just fine. It is not till I go down to row 20, starting to list
the PM shift. I use the same formulas as above , replacing the "*" with D 12,
S and N 12. At this point, it won't recognize ANYTHING in the columns!!!

My ranges/columns for counting are B7:B61 to AQ7:AQ61

What am I doing wrong???????