Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy the print settings, including header and footer fro. | Excel Discussion (Misc queries) | |||
Dynamic formulas including worksheet references | Excel Worksheet Functions | |||
How can I send an e-mail including data from a spreadsheet? | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |