T thifu3 New Member Jan 19, 2014 #1 i want to count leaves as follows A B C Name leave type leave days John off days 10 Jan annual leave 30 John off days 2 Dian sick leave 5 Deed off days 3 John off days 3 how could i calculate total off days John has taken using a formula. Last edited: Jan 19, 2014
i want to count leaves as follows A B C Name leave type leave days John off days 10 Jan annual leave 30 John off days 2 Dian sick leave 5 Deed off days 3 John off days 3 how could i calculate total off days John has taken using a formula.
aparvez007 Member Jan 19, 2014 #2 Dear thifu3, Please check attached file. Regards, pAvi Attachments Book 1.xlsx 11.9 KB · Views: 7
Hui Excel Ninja Staff member Jan 19, 2014 #3 I've added a second table to pAvi's file showing the breakdown of Day Types per Person see below Attachments Book 1.xlsx 12.3 KB · Views: 6
