Forum Discussion
Combining COUNTIF and AND functions
Is it possible to use AND with a COUNTIF function? I have a table of data and I want to count the number of occasions
Assuming you're still interested in the question you started to ask, there are definitely ways to get a count of rows that meet multiple conditions. If not through COUNTIF and AND, then through COUNT and FILTER, using FILTER to recognize the meeting of the several criteria.