I'm using Apple numbers to run some calculations on CSV export data from Mailchimp.
The data is (loosely) like:
ID Email, SignupAt 01 email@example.com 2015-09-04 02 firstname.lastname@example.org 2015-09-05 03 email@example.com 2015-09-06 04 firstname.lastname@example.org 2015-10-04
I have another table where I want to count the number of records in this table by number. Something like:
September 2015 December 2015 New Subscribers: 3 1
I've tried the following formula (and various variations of it) in my spreadsheet, but keep getting the answer
=COUNTIF(TableA:SignupAt, (MONTH(TableA:SignupAt)=MONTH(B1) & YEAR(TableA:SignupAt)=YEAR(B1)
(Where B2 is the Column header for Table B that holds the dates
What's the correct formula to count these records?