|
not including 0's
how do you not include 0's when working out averages in a huge set of data -- maksud ------------------------------------------------------------------------ maksud's Profile: http://www.excelforum.com/member.php...o&userid=26083 View this thread: http://www.excelforum.com/showthread...hreadid=394150 |
Enter the formula:
=AVERAGE(IF(A1:A100=0,"",A1:A100)) press control shift enter Mangesh "maksud" wrote in message ... how do you not include 0's when working out averages in a huge set of data -- maksud ------------------------------------------------------------------------ maksud's Profile: http://www.excelforum.com/member.php...o&userid=26083 View this thread: http://www.excelforum.com/showthread...hreadid=394150 |
Don't even need the other result
=AVERAGE(IF(A1:A100<0,A1:A100)) -- HTH RP (remove nothere from the email address if mailing direct) "Mangesh Yadav" wrote in message ... Enter the formula: =AVERAGE(IF(A1:A100=0,"",A1:A100)) press control shift enter Mangesh "maksud" wrote in message ... how do you not include 0's when working out averages in a huge set of data -- maksud ------------------------------------------------------------------------ maksud's Profile: http://www.excelforum.com/member.php...o&userid=26083 View this thread: http://www.excelforum.com/showthread...hreadid=394150 |
| All times are GMT +1. The time now is 11:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com