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:


    Whats the function for ocunting the number of elements in a row, say row 1?

    Thanks for the help!

    Kind Regards,

  • Re: counting data elements in a row

    Hi Jason

    welcome to Ozgrid



    for row 1.




    Excel MVP 2011-2014

    For more Excel memes: visit ==> 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!