|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 15th, 2010, 09:32 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average numbers in noncontiguous columns ignoring 0's.
I need to average numbers that are not in contiguous columns, and I need to
ignore zeros. Is this possible? 
|
|
#2
April 15th, 2010, 10:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average numbers in noncontiguous columns ignoring 0's.
I need to average numbers that are
not in contiguous columns Ok, tell us what columns. Tell us the specific range of cells you need to average. I need to ignore zeros. Ok, are the numbers to average *always* positive numbers? Is this possible? Probably, just need some more info. -- Biff Microsoft Excel MVP "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?
|
|
#3
April 16th, 2010, 01:23 PM
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:$A200)+($C1:$C200)+($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 | |
| Display Modes | |
|
|
Linear Mode
