Calculating holiday accrual

[carcharoth]

Hello.

Firstly, thank you in advance for any assistance. I am sure this will be very easy for those in the know!

I am using an Excel template to track holiday / sickness but the template groups all these days together. Can someone please help with a formula which will calculate the types of absence separately? Holiday / Sickness / Personal and AWOL?

Thank you so much!

 

[Chewyhairball]

Have you tried

=countif(range,criteria)

?

eg.

=countif(A4:AE,"H")

adjusting the range and criteria to suit your needs.

 

[carcharoth]

Have you tried

=countif(range,criteria)

?

eg.

=countif(A4:AE,"H")

adjusting the range and criteria to suit your needs.

Thank you!!

 

[carcharoth]

Have you tried

=countif(range,criteria)

?

eg.

=countif(A4:AE,"H")

adjusting the range and criteria to suit your needs.

Thank you