I am trying to average particular cells and exclude zeros, but I have not been able to figure it out.
I started with this formula:
=SUM(C5:C18)/COUNTIF(C5:C18,">0")
but really, it needs to be more like:
=SUM(G8,J8,M8,P8,S8,V8,AB8,AE8,AH8,AK8,AN8,AQ8,AT8,AW8,AZ8,BC8,BF8,BI8)/COUNTIF(G8,J8,M8,P8,S8,V8,AB8,AE8,AH8,AK8,AN8,AQ8,AT8,AW8,AZ8,BC8,BF8,BI8,">0")
i need to average specific cells, not a range.
HELP!
Bookmarks