Conditional Formating [Closed]

Report
Posts
2
Registration date
Thursday April 2, 2015
Status
Member
Last seen
April 2, 2015
-
 RayH -
I have a spread sheet with 2 columns; In column 1(one) I am tracking Employees. in column 2 (two), I track the employees position. When a position is Vacant, there is no name in column 1(one) - it just states VACANT.
I want to apply a formula that will automatically look at a selection and tell me the number of total VACANT positions I have as well as the total positions and will automatically update my total whenever I fill a spot or delete an employee name and make it VACANT.
Thanks for any help.

2 replies

Conditional formatting is not required to do this.

To find the total count:
=COUNTA(A1:A6)
Where range A1:A6 contains the set you want to count.

To find the 'VACANT' total:
=COUNTIF(B1:B6,"=VACANT")
Where range B1:B6 contains the 'VACANT' reference.

The values will automatically update when changed.
Posts
2
Registration date
Thursday April 2, 2015
Status
Member
Last seen
April 2, 2015

That worked, but I just realized I forgot some other data.
I have yet another column that tells the number of shifts. Anything < than 1.0 is considered part time. So now I want to know how many of my vacancies are part time and full time.
Part time:
=COUNTIF(C1:C6,"<1")

Full time:
=COUNTIF(C1:C6,">=1")

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!