Count Integer Formula In Column A:A

[soubasa]

Hello
I need a formula for counting integer numbers in column A via table
please optimize formula for column A "A:A" , "Not A2:A15"

Please look at my attached file


Thank you in advance

[AliGW]

You can use this:

=SUBTOTAL(102,Table1[Reward])

The range will grow and contract as you add and delete rows and the total will change when you filter the table.

[bebo021999]

Do you want to count "integer number" (i.e, 4) only, or "decimal number" (i,e, 4.2) include?

Count Integer number only:

Please Login or Register  to view this content.

Count all number

Please Login or Register  to view this content.

[AliGW]

Thanks for the rep. Please mark the thread as SOLVED.

[soubasa]

I Appreciate Of Your Answers


Subtotal,102 is better for me