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 ...

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 Ex...

Hi David,

 

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

Re: Which function is designed for this task in Ex...

Thanks for that.
Related Conversations
Announcement: New OneDrive Admin Center Preview
Stephen Rose  in  OneDrive for Business  on
114 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
Manage automatic creation of direct reports group
Scott Johnson  in  Office 365 Groups  on
100 Replies
MyAnalytics Outlook Add-In update rolling out!
Nick Robinson  in  MyAnalytics  on
4 Replies
Where Does End-User Adoption Start?
Anna Chu  in  Driving Adoption  on
11 Replies