July 14, 2006 at 12:18 AM #1 Hi All,I'm interested in counting the number of data elements in a row.As the function for counting the number of elements in a column are: Code counta($A:$A) Whats the function for ocunting the number of elements in a row, say row 1?Thanks for the help!Kind Regards,Jason

July 14, 2006 at 12:28 AM #2 Re: counting data elements in a rowHi Jasonwelcome to Ozgridtry=counta(1:1)for row 1.Wigi