Results 1 to 9 of 9

Thread: find the average of a cell containing digits and excluding characters and blanks

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Seeker khanaran's Avatar
    Join Date
    Jan 2013
    Location
    Lenasia South ,South Africa
    Posts
    12
    Articles
    0
    Excel Version
    2019

    find the average of a cell containing digits and excluding characters and blanks

    Hi

    I am attaching a file that needs a little modification

    The formula averages a cell contents however if there are blanks it returns an error annd if there are characters it returns an error


    Thank you in anticipation for all help

    regards

    raj
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •