View Single Post
 
Old 08-29-2022, 08:43 AM
Stillgate Stillgate is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Aug 2018
Posts: 4
Stillgate is on a distinguished road
Default Average a number of Cells excluding 0

=AVERAGE(B26,B54,B82,B110,B138)


I'm doing a average of these cells, but some of them have a value of 0, how do I exclude the zeros? I cant just remove the cell because on different spreadsheets, they will have value.

I cant use the AVERAGEIF, i cant use the range because some of the B cells have other data that dont want to use. I only want these 5 cells.
Reply With Quote