Count Ifs Formulas
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")
Help Article Resources
Check out the Formula Handbook template!