Notifications
Clear all
Topic starter
Hi,
I want the formula to count with 2 conditions.
Column B is having text and column C is having dates.
Formula must first filter column B for a particular text (ict*) and then it must filter column C in a particular date range (01/01/2016 till 31/12/2016).
I am using the formula: =COUNTIF(Tickets!B:B,"ict*")+COUNTIF(Tickets!C:C,"*2016*")
This is not working, please guide.
Please make a note that column C is in date format.
Thanks & Regards,
Derok
Posted : 05/04/2019 4:14 am
Hi Deroq
Try using COUNTIFS() instead of COUNTIF()
You can refer here on how to use COUNTIFS : https://www.myonlinetraininghub.com/excel-countif-and-countifs-formulas-explained
Please attach a sample workbook for us to take a look if you need further help.
Cheers
Sunny
Posted : 05/04/2019 12:27 pm
