Forum Discussion
Solved
Can Countifs search for criteria within a long form text?
I noticed that the data shown in D2:D6 isn't accurate. My Goal here is to have the formula count many different ticket channels within the chosen date highlighted in yellow. The problem is th...
Try this one:
=SUMPRODUCT(ISNUMBER(SEARCH(B2,'2020 All Tickets'!$E$2:$E$30000))*('2020 All Tickets'!$G$2:$G$30000>=$L$2)*('2020 All Tickets'!$G$2:$G$30000<=$L$3))
Try this one:
=SUMPRODUCT(ISNUMBER(SEARCH(B2,'2020 All Tickets'!$E$2:$E$30000))*('2020 All Tickets'!$G$2:$G$30000>=$L$2)*('2020 All Tickets'!$G$2:$G$30000<=$L$3))
Omg you're a life saver. Thank you so much >< Have a great day!
little2fern Glad i could help!
