schedule in excel with text and numbers

Hello,

I am trying to build a schedule in excel. I need to do the following 2 items:

1. I need to count how many cells are not blank (I need to count the number of cells that have any text in them) and put the total in a cell.

Basically, I need to count the number of employees on a schedule. the schedule changes and the number of employees also change.


2. I need to calculate the number of available employees on a date. there are several types of employees. they are coded in a column and i need to know how many of each type i have available each day.

For example:

each row has;
A B C D E F G H I
1 employee qualification day1 day2 day3 day4 day5 day6 day7.....
2 John smith A NS NS NS
3 Bill Jones I NS
4 Tom Jones A NS NS
5 Mike Smith A NS NS


Total A techs 2 2 0 2 2 3 2
Total I techs 1 0 1 1 1 1 1


I was looking for a formula on the line of :

COUNT IF C2:C5 = "" and B2:B5 = "A"



I would appreciate any help.

Thanks






each day is either blank (working) or NS ILL DIS LO.....

i

1. The COUNTA(range) function will count non-blank cells in a range.


2. I've included a spreadsheet (done in XL 2K) with what I think you want to accomplish. If it isn't, post a stripped down version of the workbook (you'll have to zip the workbook in order to post it) with an example of the data and what you wish to achieve. It is hard to determine what you are trying to accomplish with the data you've provided.

Thank you very much, it is exactly what I was looking for.