gr8trthanu
Board Regular
- Joined
- Nov 14, 2008
- Messages
- 103
Good Morning,
I have data in cells C4,I4,O4,U4,AA4 that I require to find the average of and display in AL4.
I do not want "0" or blank cells to be included in the average.
I tried using the following formula but getting an error because the cells are not in a range
*****CODE******
=AVERAGEIF(C4:AA413,"<>0")
Is there another method to this?
Thanks in advance.
I have data in cells C4,I4,O4,U4,AA4 that I require to find the average of and display in AL4.
I do not want "0" or blank cells to be included in the average.
I tried using the following formula but getting an error because the cells are not in a range
*****CODE******
=AVERAGEIF(C4:AA413,"<>0")
Is there another method to this?
Thanks in advance.