Forum Discussion
Solved
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 statisti...
=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.
Tried, and managed to get a total number of emails between specific times, but still need to could categories between specific times. can a CONTIFS or COUNTIF specify the times and count a category?
=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.
- Modified the layout to match and this and it seems to work. May just look to tidy up the display by storing the email list on another tab and looking up the data using the tab and !. Thanks and think this is the answer, though may just need to modify the time data each time, but this will make the process easier I think. Thanks for your help.