counting data elements in a row

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    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

    Re: counting data elements in a row


    Hi Jason


    welcome to Ozgrid


    try


    =counta(1:1)


    for row 1.


    Wigi

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login