Results 1 to 2 of 2

Thread: Formula to count how many different months based on employee

  1. #1
    Neophyte Cityscape123's Avatar
    Join Date
    Oct 2021
    Posts
    2
    Articles
    0
    Excel Version
    2016

    Formula to count how many different months based on employee



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    I am trying to find out a formula to input a number if the employee has been absent on particular months. Please see attachment, the last column “Result” should be populated as follows:

    If employee absent in April and May and/or June = 2
    if only absent in April = 1
    if only absent in May and/or June = 2



    Thanks
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Table.png 
Views:	9 
Size:	62.7 KB 
ID:	10657  

  2. #2
    Neophyte Cityscape123's Avatar
    Join Date
    Oct 2021
    Posts
    2
    Articles
    0
    Excel Version
    2016
    This has been resolved so please ignore, thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •