I want to average a column that is all percentages, but I want to excluding
any cells with a 0%, what formula would I use? Thanks!!!
I want to average a column that is all percentages, but I want to excluding
any cells with a 0%, what formula would I use? Thanks!!!
There may be a snappy built-in function in Excel to do this, but until
someone responds with it, this formula will work:
=SUM(D1:D5)/COUNTIF(D1:D5,"<>0")
.... where D1:D5 is the range containing your percentages.
Maybe..
=SUM(A1:A10)/COUNTIF(A1:A10,"<>"&0)
KMHarpe wrote:
>
> I want to average a column that is all percentages, but I want to excluding
> any cells with a 0%, what formula would I use? Thanks!!!
--
Dave Peterson
Probably not a good idea to average %s anyway. Get your average from the data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks