Results 1 to 4 of 4

Thread: "Value" error in "Average Function"

  1. #1

    "Value" error in "Average Function"



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am getting a VALUE error when trying to average a range of cells that contain zero values & the range of cells also contain formulas. My formula for the range is "=AVERAGE(IF(B4:AY4<>0,IF(B4:AY4<>"",B4:AY4)))" which solved the zero problem but it would seem that i am now getting the VALUE error due to text being in the cell range. Any suggestions, Regards Darren

  2. #2
    Your formula is doing fine, it will ignore text too..

  3. #3
    Quote Originally Posted by Rizky View Post
    Your formula is doing fine, it will ignore text too..
    I forgot to add that some of the cells contain formulas, is this my problem ?

  4. #4
    Doesn't seem to make a difference that I can see, can you post the workbook?

Posting Permissions

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