First off, my apologies if this has been answered somewhere. I skimmed thru the first couple of pages of headlines and didn't find an answer.
I need to average a row of cells, but only need to include that cell if the value is greater than 0.
I'm a novice at Excel. Ya know, just enough to be dangerous....
Thanks in advance.
Kristi
Put this formula in the cell you want the average to show
Change the 11:11's to the row of cells you need to sum
Please Login or Register to view this content.
Last edited by gmr4evr1; 03-02-2015 at 04:46 PM. Reason: Changed from columns to rows
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
What gmr said except you can use AVERAGEIF(A1:Z1, ">0", A1:Z1)
assuming data is in A1:Z1
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Go with ChemistB's solution, I forgot you wanted the average of the cells, not the sum.
That works!! Thanks guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks