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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|