Now I have 3 sheets.
On the 3rd sheet I have 2 list of data column A1, a2, a3,a4 counts the data as Landline, Mobile, All Males, All Females.
Were as on the same sheet I have in Column H1, h2,h3 151, 152, 153.
And on sheet2 I have a column as time as r1,r2,r3 (format is mm:ss:0).
And on sheet1 I have time, I just need to count.
Time Landline
9:00:00 =countif(
10:00:00
The problem is it should take the column A1, and H1,H2,H3 from sheet 3 as criterias and time from sheet2 r1,r2,r3. should give the count to landline numbers in sheet1, the sheet1 time will be >=9:00:00 <10:00:00.
Any macro or formula or any other way will be a great help.
thanks.
On the 3rd sheet I have 2 list of data column A1, a2, a3,a4 counts the data as Landline, Mobile, All Males, All Females.
Were as on the same sheet I have in Column H1, h2,h3 151, 152, 153.
And on sheet2 I have a column as time as r1,r2,r3 (format is mm:ss:0).
And on sheet1 I have time, I just need to count.
Time Landline
9:00:00 =countif(
10:00:00
The problem is it should take the column A1, and H1,H2,H3 from sheet 3 as criterias and time from sheet2 r1,r2,r3. should give the count to landline numbers in sheet1, the sheet1 time will be >=9:00:00 <10:00:00.
Any macro or formula or any other way will be a great help.
thanks.