Translate gsheet expression

[J_jvs]

Hi Team,
anybody could translate me this expression “=value(COUNTIFS($B$2:B2;B2;$A$2:A2;A2))” ?

b= [dia]
a= [user]

thks in advance

[J_jvs]

nobody?

[J_jvs]

I want to count same values of column c, is not possible?

[Steve]

Try:

COUNT(
  FILTER(
    "MyTable",
    AND(
      ISNOTBLANK([SomeColumn]),
      ([SomeColumn] = [_THISROW].[SomeColumn]),
      ([_ROWNUMBER] <= [_THISROW].[_ROWNUMBER])
    )
  )
)