Skip to Content

Formula to Count rows in a table by qualification

Hi experts,

Please provide the solution how to better count rows in table with some qualification.

Here below my example with rows in table

ID Text Date Comment NewColumn(Count)

10001 test1 12/12/12 terter (need to be 2 as ID duble)

10001 test2 12/11/11 terterte (2)

10002 gdfgdf 13/11/12 gdfgdfgdf (1)

10003 gfdbvcdf 14/11/12 gjtrhtrdfk (1)

10004 gdfgdf 12/11/12 cvbnjhkrt (1)

10006 utr45 11/10/10 ggndfmgn (2)

10006 utr67 11/11/11 jfdgnjdfjgdf (2)

Count depend on ID

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 28, 2017 at 01:55 PM

    use this.

    =Count([ID];All) In ([ID])

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 28, 2017 at 03:36 PM

    Many thanks, Amit!

    It really works!

    Add comment
    10|10000 characters needed characters exceeded