Percent averaging

looking to average a small column of percents, but some are zero. What is the formula

Hi,

Try

Formula:

Please Login or Register  to view this content.

where [range] is the range containing your percentages that you wish to average.

Hope this helps

THAT'S IT, THANKS!
How do I now let everyone know I have the answer?

Click on "Thread Tools" above your first post and select "Mark As Solved".

Also, please don't forget to say thanks by clicking on the * to the bottom-left of my post.

Thanks

Yes, but the database for a column has not been filled in, I need for it to return a value of 0 to keep a running yearly total. how?

Sorry Craig, I'm not sure I understand what you mean by that last post...could you please elaborate on that?

Sure, First u have my tks for the earlier info on how to say tks and end thread.
Since my table is not fully populated and will not be until the end of the year, I have running totals for the columns of various items and when I input the averageif the running total goes to "#div/0!". I kept the running totals active so each day,week and month I know the current amt?