Forum Discussion
Excel formula assistance
Countif / Countifs have issues due to the time format and pivot table options have not worked very easily either. Looking to create a list which other workbooks can use at the same time for statistic purposes.
Copied a number of emails from outlook to count the number of emails processed during set time periods, but only way it works is a time consuming process.
Looking to use formula to group emails during the various time periods I have been asked to count.
Just not sure if there may be another formula option I have not considered.
=COUNTIFS($C$2:$C$10000,">="&$G2,$C$2:$C$10000,"<"&$G3,$E$2:$E$10000,I$1)I'd apply COUNTIFS as shown in the screenshot.
=COUNTIFS($C$2:$C$9,">="&E2,$C$2:$C$9,"<="&F2)In general you can use COUNTIFS like in the example. In the columns A to C is the information copied into Excel.
However i'm sure that the layout of your real data is different. Maybe you can attach a screenshot of your data without sensitive data and with your intended result.Below is an example of the emails copied (ctrl c from outlook) and pasted in excel (ctrl v) but I have modified emails and categories. Appreciate if you can offer any suggestions to make the count process easier. Think the issue relates to the time format as suggested COUNTIF / COUNTIFS has had problems and think it is due to the time format
So, that's only time, not datetime? Anyway, I guess PivotTable shall work.
What the entire procedure is? In general you may use Power Query to pick up emails from available mailbox(es), make the transformation and generate any metrics you wish.
If not Power Query, how do you import emails information to the Excel?
- We just copy and paste the outlook data into excel (ctrl C & V process)
