Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count ifs with variable range

Hello Community,    I'm using a Count ifs in excel like this  =COUNTIFS($C$1:C18;C18;$A$1:A18;A18;$B$1:B18;B18) Notice that I have a variable range that changes with the rows. I need to do the s...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I solved it.

     

    CALCULATE(
    COUNTROWS('Table'),
    FILTER(
    'Table',
    'Table'[A] = EARLIER('Table'[A])
    && 'Table'[B] = EARLIER('Table'[B])
    && 'Table'[C] = EARLIER('Table'[C])
    && 'Table'[Index] <= EARLIER('Table'[Index])))
themistoklis's avatar
themistoklis
Community Champion
5 years ago

Hello Anonymous ,

 

You can try the following formula:

 

COUNTIFS =
CALCULATE (
    COUNTROWS ( Table ),
    FILTER (
        Table,
        Table[A] = [A]
            && Table[B] = [B]
                && Table[C] = [C]
    )
)

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I solved it.

 

CALCULATE(
COUNTROWS('Table'),
FILTER(
'Table',
'Table'[A] = EARLIER('Table'[A])
&& 'Table'[B] = EARLIER('Table'[B])
&& 'Table'[C] = EARLIER('Table'[C])
&& 'Table'[Index] <= EARLIER('Table'[Index])))