May 31 2022 01:36 PM
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
May 31 2022 02:10 PM
You may use COUNTIFS function (microsoft.com) or, perhaps, PivotTable
May 31 2022 02:26 PM
thank you. I need more help than that…. Can you give more specific on the formula?
-Betty
May 31 2022 02:43 PM
=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.