New Contributor

## COUNTA formula in Anaplan

Hi,

I was wondering if there is in Anaplan the equivalent of the "COUNTIF" Excel formula: basically counting the cells in that range that match a specific condition. I was thinking of using it for calculating the % of Cost Centres that have input data so far against the one that have no values.

Guido

1 ACCEPTED SOLUTION

Accepted Solutions
Master Anaplanner/Community Boss

## Re: COUNTA formula in Anaplan

As shown below

Now this is a very simple example, and if it is a simple as this, then there is no need to split the condition into a separate line, but if the condition starts getting complex, it is better to split it up as per 2.02-18 in the Planual

https://community.anaplan.com/t5/Planual/ct-p/Planual

I hope this is clear

David

3 REPLIES 3
Master Anaplanner/Community Boss

## Re: COUNTA formula in Anaplan

Unfortunately not

You will need two line items:

One for calculate the condition

One to hold the value for the TRUE state (IF condition THEN value else 0)

David

New Contributor

## Re: COUNTA formula in Anaplan

Hi David,

Thanks a lot for the reply.

Can you be a little more specific and give me an example?

Thanks,

Guido

Master Anaplanner/Community Boss

## Re: COUNTA formula in Anaplan

As shown below

Now this is a very simple example, and if it is a simple as this, then there is no need to split the condition into a separate line, but if the condition starts getting complex, it is better to split it up as per 2.02-18 in the Planual

https://community.anaplan.com/t5/Planual/ct-p/Planual

I hope this is clear

David