Here is a link to a sample spreadsheet:
https://docs.google.com/spreadsheets/d/1LcfqPxsnQGEVZKd2imM1WPYRvgbZBiEQ18mHVd3znjE/edit?usp=sharing
What I want to do is count all unique values in column C (ID) and all values in column A (initial email) in the month of November.
This is the best I could come up with:
=COUNTUNIQUE(FILTER(Sample!C2:C,Sample!A2:A="Mon, Nov. 23, 2015 2PM"))
But it would only count one specific date in November so I would have to also count all the other dates and then total them. Is there a way for the formula to count all unique values in column C and count all values in Column A containing "Nov"? To add to that, I also need to count all values in Column F (Response category), containing unique ID for the month of November.