Forum Discussion
Solved
How to use Countif for BOTH date range plus one more criteria?
My Goal I'm aiming to make an interactive dashboard on excel for data about my company's customer service tickets issue that we receive each day. - There're many different ticket issues and I want ...
Hi little2fern
You master data must have "Ticket Issue" column you need to add that one also in the criteria
attached is the sample file for your ready reference
=COUNTIFS($B$2:$B$26,">="&$J$2,$B$2:$B$26,"<="&$J$3,$C$2:$C$26,$F2)Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
Hi little2fern
You master data must have "Ticket Issue" column you need to add that one also in the criteria
attached is the sample file for your ready reference
=COUNTIFS($B$2:$B$26,">="&$J$2,$B$2:$B$26,"<="&$J$3,$C$2:$C$26,$F2)
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
- Thank you so much. It is working now!
