active rows in table feature of excel

[paramnayak]

is it possible to calculate the number of active rows in table feature of excel.

actually i have to add all the values in a particular column in 1st row of my table (something like sum(a:a)) so count forumla will not help. also i don't want to use A:A because chance of error will be there if some value is put in the column outside the table

 

[bobhc]

Good day paramnayak

You may find this of help

http://www.dummies.com/how-to/content/counting-cells-in-excel-2010-with-count-counta-and.html

 

[paramnayak]

it was helpful. thanks a lot