Can I get help with formula to count number of sold notifications current month?

JANET WEEKS

This formula is giving me an Invalid Data Type message. I am trying to do this in Sheet Summary.

=COUNTIF([Date Sold Notification]:[Date Sold Notification], MONTH(@cell) = MONTH(TODAY()))

Leibel S

Try the below:

=COUNTIFS([Date Sold Notification]:[Date Sold Notification], ISDATE(@cell), [Date Sold Notification]:[Date Sold Notification], MONTH(@cell) = MONTH(TODAY()))

Mike Wilday

Do you have empty date cells in your date range? I received that error when I had some empty date fields in that range. Try adding an iferrror to your formula like this...

=COUNTIF([Date Sold Notification]:[Date Sold Notification], IFERROR(MONTH(@cell),0) = MONTH(TODAY()))

This will make any blank cells count as 0 and will then give you your final count.

Leibel S

Try the below:

=COUNTIFS([Date Sold Notification]:[Date Sold Notification], ISDATE(@cell), [Date Sold Notification]:[Date Sold Notification], MONTH(@cell) = MONTH(TODAY()))

Mike Wilday

Do you have empty date cells in your date range? I received that error when I had some empty date fields in that range. Try adding an iferrror to your formula like this...

=COUNTIF([Date Sold Notification]:[Date Sold Notification], IFERROR(MONTH(@cell),0) = MONTH(TODAY()))

This will make any blank cells count as 0 and will then give you your final count.

JANET WEEKS

Thank you...It worked.

Mike Wilday

Awesome, glad we got it working for you. Please accept our answers. :)

Bassam Khalil

Awesome @Mike Wilday