Hi,



Here is another problem from me. i've been doing this for month but nothing.

I want to create a database table in sheet1, preferably with drop down button (create from name manager and validate the cell with list and the name right?).
the data is across 200 sheets.

what i'm trying to achieve is by selecting designated technician in 1st column, required date in 2nd column and specific time frame (either 12am-12pm or 12pm-12am) in 3rd column, i will get the count of results across the sheets.

My main problem is use the right formula for it to differentiate the 12hrs time frame and to count the data across the sheets, i guess i can use COUNTIF.

Pls help me..

Regards,
Udea

Attached Files

Book2.xlsx (11.5 KB, 12 views)