Counting text in range subtracting from par

With the help of daddylonglegs on this forum, I have created a schedule that works very well for what I am trying to do. The issue I am having now, is taking a range of cells, checking to see if it has text, adding the number of cells in the range together, and subtracting it from a par. I have tried using the sumif function, which, by my programming, gave me an error everytime, and I have tried this code as well.

Please Login or Register  to view this content.

It's subtracting from the par, but it's not adding the cells containing the text together first. Will someone point me in the right direction? Thank you !!

I found the solution to my question. If anyone's interested, here's what I found that works.

Please Login or Register  to view this content.

So far, so good!

With the solution I have used, I have one more item I am trying to figure out that is eluding me. In the schedule, I use an "x", and an "r". x for day can't work, r for requested day off. The counta works great, but doesn't account for these two items. I have tried using sum, countif, if, and nothing is seeming to work. Anyone have an idea?? Attached is what I am currently working on. Thanks!!