Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count based on 2 conditions by using vb
Greeting,
I have 5 columns A,B,C,D ,& E. A has the date and B&C have names for shift workers (day) D& E have shift workers (Night). Also I have 5 cells (G3, G4, G5,G6&G7). All these Cells is for Search criteria. G3 is Start Date, G4 is for End date G5 is for Name G6 is for Shift type(Day or Night) G7 is for calculating how many time employee has appeared in between two date and selected shift time(day or night) Also, I have a summary table for storing the values in G7 after name updated My question is how to store these values in the summary table once I click on command button? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count based on Conditions | Excel Worksheet Functions | |||
COUNT based on conditions in 2 or more columns | Excel Worksheet Functions | |||
Count based on multiple conditions | Excel Discussion (Misc queries) | |||
How do I count based on two conditions? | New Users to Excel | |||
Count Based upon Multiple Conditions | Excel Worksheet Functions |