Combining CountIfs statement with Date

Devon Eddy · 08/31/20

I have a CountIfs formula that I'm having trouble getting to work when I add a date condition into it.

Basically I'm trying to get a MTD output based on several countifs as well as only counting if an adjecent cell does not contain "Appointment Allowcated". The formula works perfectly when I don't have the IFERROR statement as part of the formula but doesn't work when I add it.

Here it is: =COUNTIFS({Pipedrive - Smartsheet Range 11}, ="Appointment Scheduled", {Pipedrive - Smartsheet Range 13}, ="", {Pipedrive - Smartsheet Range 2}, NOT(CONTAINS("Appointment Allocated", @cell)), {Pipedrive - Smartsheet Range 15}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))

Hope I can get some help! Thank you

David Joyeuse · 08/31/20

Hi @Devon Eddy

The IFERROR formula should be like this I believe:

IFERROR(MONTH(@cell)=MONTH(TODAY()),0)

I'm not sure why do you need an IFERROR here. Is there anything special with your {Pipedrive - Smartsheet Range 15}?

Hope it helped!

Paul Newcome · 08/31/20

You have the IFERROR portion correct.

IFERROR(MONTH(@cell), 0) = MONTH(TODAY())

Are you getting an error or are you getting an incorrect count?

David Joyeuse · 08/31/20

Combining CountIfs statement with Date

Answers

Help Article Resources

Categories