| 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
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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. |
|
#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 | |||
Linear Mode
