Count Ifs Formulas

Kate

I have created formulas to count the number of incoming quotes by month and according to if they have been Won/Lost/Pending. I use the exact same formula for March (month 3) and it works beautifully. For some reason the formula is not pulling in the info we have loaded up so far in April:

=COUNTIFS([Conversion Status]:[Conversion Status], "Pending", [Date Requested]:[Date Requested], MONTH(@cell) = "4", Year:Year, "2018")

Shaine Greenwood

Hi Kate,

Remove the quotes around 4 and 2018 or else your function will treat them as text:

=COUNTIFS([Conversion Status]:[Conversion Status], "Pending", [Date Requested]:[Date Requested], MONTH(@cell) = 4, Year:Year, 2018)