Conditional Formating
Closed
rduncanhoops
Posts
2
Registration date
Thursday April 2, 2015
Status
Member
Last seen
April 2, 2015
-
Apr 2, 2015 at 03:59 PM
RayH - Apr 3, 2015 at 01:29 PM
RayH - Apr 3, 2015 at 01:29 PM
Related:
- Conditional Formating
- Conditional formatting 3 color scale percentages ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Conditional hyperlink excel ✓ - Excel Forum
- Conditional formating of row based on other cells - Excel Forum
- Conditional formatting based on date ✓ - Excel Forum
2 responses
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.
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.
rduncanhoops
Posts
2
Registration date
Thursday April 2, 2015
Status
Member
Last seen
April 2, 2015
Apr 2, 2015 at 05:02 PM
Apr 2, 2015 at 05:02 PM
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.
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.
