calc from drop down list

[qasha200]

Hi all

well , i need to calc from drop down list

i used countif formula but not sucessed

any help

find attached spread sheet Manpower managment test.xlsx

[Anka]

Hi

For best result should be more explicit.

Use this:
1. For On duty

Please Login or Register  to view this content.

Number of cells ending with the letters "on" and "another word".


2.For Off duty

Please Login or Register  to view this content.

Number of cells ending with the letters "ff" (from off) and "another word".


3.For "S.Leave"

Please Login or Register  to view this content.

Number of cells with "S.Leave"


4.For "Leave"

Please Login or Register  to view this content.

Number of cells with "Leave"

If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>Mark your thread as Solved. And maybe click on below * if this helps.

[qasha200]

hi
thanks . it solved already

really appricated

regards