Countif

vmjan02

Well-known Member
Joined
Aug 15, 2012
Messages
601
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.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,108,788
Messages
5,524,879
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top