Add and count
Average while ignoring zeros
=AVERAGEIF(B2:B5,"<>0")How it works in Excel
- "<>0" keeps every number except 0.
- Empty cells are already ignored by AVERAGE.
The idea in general
A zero can mean "no data", and it would drag the average down.
What I assumed
- Your numbers are in B2:B5.
Check the result on your own data before relying on it.