Hey everyone,
I'm trying to pull the average of a row where but want to exclude any cells that have a value of 0.
I'm sure this is quite simple but can't for the life of me work it out.
Any ideas?
For excel 2010
Hey everyone,
I'm trying to pull the average of a row where but want to exclude any cells that have a value of 0.
I'm sure this is quite simple but can't for the life of me work it out.
Any ideas?
For excel 2010
you have excel 2010 there's a function averageif
=AVERAGEIF(A1:A100,"<>0")
or
=SUM(A1:A100)/COUNTIF(A1:A100,">0")
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
This fixed it, thanks!
Tour welcome any time. Can you mark this thread "solved" thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks