Home

Which function is designed for this task in Excel 365

Highlighted
David Ashby
New Contributor

Which function is designed for this task in Excel 365

I download a csv file that I save as an Excel file. This file has data related to multiple shift patterms such as days or nights along with the days or nights of the week they are scheduled.

 

I have a filter set so that none of the day shifts show however I am looking for the best formulae to use so that the 4 or 5 night shift codes are the only rows counted.

 

I basically want to know how many night shift employees are listed but do not want any day shift data being counted.

 

The shift codes start with D for days N for nights, example NN2-1900

 

Can anyone advise?

 

Thanks

  • Need Help
  • Tips and Tricks
2 Replies

Re: Which function is designed for this task in Excel 365

Hi David,

 

You may use COUNTIF() with "N*" as criteria.

Re: Which function is designed for this task in Excel 365

Thanks for that.
Related Conversations
Announcement: New OneDrive Admin Center Preview
Stephen Rose  in  OneDrive for Business  on
119 Replies
Cost estimator for small scale catering
Louisa Dira  in  Excel  on
12 Replies
How to convert date format from imported data?
Reuben Helder  in  Excel  on
9 Replies
How to group rows of data with text
Jason Loscar  in  Excel  on
4 Replies
Managing Office 365 - An Overview
Kim Kischel  in  Office 365  on
5 Replies