"Value" error in "Average Function"

daza18

New member
Joined
Jul 4, 2014
Messages
2
Reaction score
0
Points
0
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
 

Rizky

New member
Joined
Apr 28, 2014
Messages
44
Reaction score
0
Points
0
Your formula is doing fine, it will ignore text too..
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Doesn't seem to make a difference that I can see, can you post the workbook?
 
Top