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

@betty2001 

You may use COUNTIFS function (microsoft.com) or, perhaps, PivotTable

@Sergei Baklan 

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

-Betty

@betty2001 

=SUMPRODUCT((ROUNDUP(MONTH($C$2:$C$25)/3,0)=D6)*(E6=YEAR($C$2:$C$25))*($G$2=$A$2:$A$25)*($G$3=$B$2:$B$25))

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.