Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I average a column without including zeros
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!!! |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Probably not a good idea to average %s anyway. Get your average from the data. -- pgriff ------------------------------------------------------------------------ pgriff's Profile: http://www.excelforum.com/member.php...o&userid=26189 View this thread: http://www.excelforum.com/showthread...hreadid=394952 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match and count words | Excel Worksheet Functions | |||
Average of column entries | Excel Discussion (Misc queries) | |||
I need to find the Average from Column A - but Reference Column B | Excel Worksheet Functions | |||
EXcluding Zeros from the average in a row | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |