| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average numbers in noncontiguous columns ignoring 0's.
Something like this:
=SUM($A1:$A20,$C1:$C20,$E1:$E20)/SUMPRODUCT(($A1:$A20<0)+($C1:$C20<0)+($E1:$E20< 0)) HTH Steve. "bean counter" <bean wrote in message ... I need to average numbers that are not in contiguous columns, and I need to ignore zeros. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hlookup and sum noncontiguous numbers | Excel Worksheet Functions | |||
| average of 12 noncontiguous cells | Excel Discussion (Misc queries) | |||
| Calculate the average of numbers, ignoring multiple values | Excel Discussion (Misc queries) | |||
| Need help with formula to average numbers while ignoring "0" value | Excel Worksheet Functions | |||
| Averaging noncontiguous numbers ignoring zeros? | Excel Worksheet Functions | |||
Threaded Mode
