Count Ifs Formulas

Kate

I need help figuring out why this formula is returning Invalid Data Type:

 

=COUNTIFS([Conversion Status]:[Conversion Status], "Won", [Date Requested]:[Date Requested], MONTH(@cell) <= "3", [Year]:[Year], "2017")

 

I want to count the number of lines that have a Conversion Status of "Won" that also took place in March of 2017

L_123

It looks like the error was from you having blanks in your date requested column when conversion status wasn't blank. More the fault of the program than your fault, it gets touchy when you mix date and text types in formulas. Use another command to stop it if the date requested is blank

=COUNTIFS([Conversion Status]:[Conversion Status], "Won", [Date Requested]:[Date Requested], ISDATE(@cell), [Date Requested]:[Date Requested], NOT(MONTH(@cell) > 3), Year:Year, 2017)

Kate

Luke- That's it! I couldn't get the formula to work but when I went back to make sure all of the dates were filled in it didn't result in an error. Amazing-thank you so much!