Count Ifs Formulas

edited 12/09/19 in Formulas and Functions
03/21/18 Edited 12/09/19

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

Popular Tags:

Comments

  • L@123[email protected] ✭✭✭✭✭

    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)

  • 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!

Sign In or Register to comment.