sg117098 Do you have codes that identify the type of leave taken? I have put this example sheet together which may help. Happy to try and amend if you have an example =(COUNTIF(C4:C22,"Holiday"))+(COUNTIF(C4:C22,"sick"))+(COUNTIF(C4:C22,"Training"))+(COUNTIF(C4:C22,"Vacation"))

Forum Discussion

sg117098

Copper Contributor

Jul 10, 2023

Formulas

Formulas and Functions

1 Reply

Gemma Telfer
Copper Contributor
Jul 11, 2023
sg117098 Do you have codes that identify the type of leave taken? I have put this example sheet together which may help. Happy to try and amend if you have an example

=(COUNTIF(C4:C22,"Holiday"))+(COUNTIF(C4:C22,"sick"))+(COUNTIF(C4:C22,"Training"))+(COUNTIF(C4:C22,"Vacation"))
schedule formula.xlsx14 KB