Hey,
I am a big novice when it comes to Excel and I am trying to make a formula to count a few bits of data.
What I need is for the formula to look at column F and count a specific time range i.e if any times displayed are between 9am-12pm. The extra condition is in Colum F there will be either a number 1 or a number 3.
The end result would to have 2 boxes that count the amount of inputs in F between 9-12 compared to what is displayed in F.
An example of the data inputted would be;
F --------- H
09:00----- 1
09:18----- 3
10:25------1
10:36----- 1
11:34----- 3
The end result - 1 = 3
--------------------- 3 = 2
Would this be possible?
Thank you in advance for your reply's.
Bookmarks