Help with formula

New Contributor

I have a table with 3 columns.  Column A & B have text, column C has dates.-  I need to count how many times column C has dates in a specific quarter/year, only when column A has X text and column B has Y text.  Can you help me with that formula?

Thanks! -Betty

3 Replies


You may use COUNTIFS function ( or, perhaps, PivotTable

@Sergei Baklan 

thank you.  I need more help than that…. Can you give more specific on the formula?




An alternative could be SUMPRODUCT. In the attached file you can dynamically select x text and y text with the dropdowns in cells G2 and G3.