I am not sure if this is the proper way for a reply. If it is thanks for the help looks like I am makeing some progress here. Now I need help with a formula. Something like: COUNTIF('sheet 1"!
A10 is T or A (T=Trady A=Absent)..... if A to ('Sheet 2'! D10 total if T add to Sheet !2 E10 total
|Absensce Formula Calculation.xls|
|1||Absensce Formula Calculation|
|2||Days Absent||No of Days||Percentage based on 100|
|3||percentage achieved*100/days in total|