Anaplan's equivalent of a COUNTIF function

robert_mahlum

Anaplan's equivalent of a COUNTIF function While Anaplan doesn't have an official COUNTIF function like Excel, you can combine an "IF THEN" statement with a "SUM" function to accomplish the same goals. Using the "IF THEN ELSE to create a count saying "IF True Then 1 Else 0" You can then use a SUM Function to get the value of that line item total. https://community.anaplan.com/anapedia/calculation-functions/IF-THEN-ELSE https://community.anaplan.com/anapedia/calculation-functions/sum