Snip1.PNGSnip2.PNG
I hope someone is able to help on some data analysis I'm currently working on. I'm trying to make everything as time efficient as possible so interested to hear the best way to go about this.
The attachments above demonstrate the 2x Worksheets I am working with, raw data and main sheet.
What I would like to pull is use multiple countifs or a suggest alternative to lookup the raw data and based on the values return a number on the main sheet for the relevant section.
So for example - I need a formula that looks at all the raw data A1:I12
On the main sheet I then need returned values for the number that refer to that sections criteria so for example
How many applications were received within the specified hour (Column B) so on the raw data it would look down Column G for any applications received between 00:00:00 and 00:59:99 then a separate calculation for column H to work out whether it was answered within a specified time period, 30mins between Column G & H time
Hope the above makes sense, although reading it back it probably doesn't
Any support would be great though
Bookmarks