
New Member

April 4, 2019

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

VIP

Trusted Members

June 25, 2016

Hi Deroq
Try using COUNTIFS() instead of COUNTIF()
You can refer here on how to use COUNTIFS : https://www.myonlinetraininghu.....-explained
Please attach a sample workbook for us to take a look if you need further help.
Cheers
Sunny
1 Guest(s)
