counting results of a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting text problem - formula works initially 3
Text to number value 1
COUNT IF NOT.... 4
Show me your highest mileage HDD? 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
Subtracting time...again 2
Count Employee Work Time - Don't Count Duplicates 3
Sum if or sum product? 5

Back
Top