counting results of a list
I have to make an electronic schedule for nurses which includes both day and
nite shifts . I have used the "list" function and it quickly sorts out only the day shift for me but it still gives me the wrong total now because it is still counting the nite shift crew in the numbers. day day pm day day total = 4 pm total = 4 |
What is the list function? Are you counting from the extracted data?
-- HTH Bob Phillips "ferde" wrote in message ... I have to make an electronic schedule for nurses which includes both day and nite shifts . I have used the "list" function and it quickly sorts out only the day shift for me but it still gives me the wrong total now because it is still counting the nite shift crew in the numbers. day day pm day day total = 4 pm total = 4 |
Hi,
Not sure by what you mean ny saying "list function" but you can use the countif function (Help available in Excel). Regards, Ashish Mathur "ferde" wrote: I have to make an electronic schedule for nurses which includes both day and nite shifts . I have used the "list" function and it quickly sorts out only the day shift for me but it still gives me the wrong total now because it is still counting the nite shift crew in the numbers. day day pm day day total = 4 pm total = 4 |
All times are GMT +1. The time now is 11:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com