COUNTIF between two dates

Hi 'bella,

You've removed the commas from the circled areas, leaving the semi colons.

Assuming this is correct for your region, you'll also need to change the rest of the commas in the formula to semi colons as well.

(I do have some doubts regarding this advice, as the formula is displaying the coloured tokens for cell references here. I would expect to see a simple text display if Numbers were not recognizing this as a formula. Will check in again later in the day.)

Regards,

Barry

The function countif() sums when a single condition is true

there is a sister function countifs() which sums only when multiple conditions are true

you can do something like this:

Name the table where you enter registrants "Registration Data" and the summary table on the right "Registration Summary"

make the first row of both tables a header row

In the table on the right ("Registration Summary"), select cell B2, then type (or copy and paste from here) the formula:

=COUNTIFS(Registration Data::A, ">="&DATE(YEAR(A2), MONTH(A2), 1),Registration Data::A, "<="&EOMONTH(DATE(YEAR(A2), MONTH(A2), 1),0))

short hand for this is:

B2=COUNTIFS(Registration Data::A, ">="&DATE(YEAR(A2), MONTH(A2), 1),Registration Data::A, "<="&EOMONTH(DATE(YEAR(A2), MONTH(A2), 1),0))

to fill down, select cell B2, copy

select cells B2 thru B13, paste

heybella,

There ae three syntax errors in the formula:

The separator in the three circled places should be a comma OR a semi colon.

Use a comma ( , ) if your region uses a period ( . ) as the decimal separator: $1.23

Use a semi colon ( ; ) if your region uses a comma ( , ) as the decimal separator: €1,23

Regards,

Barry