Need help w/a counting formula

  • Thread starter Thread starter Valerie Moore
  • Start date Start date
V

Valerie Moore

I have a worksheet that I would like to have automatically
count the number of people that are on break/lunch or
working at any given time. I found the "COUNTA" function
but that doesn't differentiate between
break/lunch/working, it just counts anything in the cell
range. I have included a small example below - basically
what I need to get from it is that at 7:00 there is 1
person at break, 1 at lunch and 1 working etc...

7:00 7:15 7:30
B W W
W L L
L W B

Is there any way to have this automatically update so I
don't have to manually count the cells myself each time
there is a change? Thanks in advance!!
 
Hi Valerie
You could do the following. If your data is in say A1:C3
In A4 put =COUNTIF(A1:C3,"W")
IN B4 put =COUNTIF(A1:C3,"B")
In C4 put =COUNTIF(A1:C3,"L"), etc,etc
You can then manipulate your data further from there.
Regards
Michael
 
Thanks Michael - that is exactly what I needed!
-----Original Message-----
Hi Valerie
You could do the following. If your data is in say A1:C3
In A4 put =COUNTIF(A1:C3,"W")
IN B4 put =COUNTIF(A1:C3,"B")
In C4 put =COUNTIF(A1:C3,"L"), etc,etc
You can then manipulate your data further from there.
Regards
Michael
.
Click to expand...
 
Back
Top