Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another Average non-adjacent cells question...
I have two non-adjacent cells that I want to average but throw out one
of the numbers if one of them is zero...I used this and it works fine with adjacent cells but stumped on getting it to work with two non-adjacent cells. My cells are F3 and K3. =AVERAGE(IF(B2:C2<0,B2:C2," ")) CTRL+SHIFT+ENTER Thanks for any help I get on this... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another Average non-adjacent cells question...
Hi!
One way: =IF(COUNT(F3,K3)<1,"",SUM(F3,K3)/SUMPRODUCT(--(MOD(COLUMN(F3:K3),5)=1),--(F3:K30))) Biff wrote in message ups.com... I have two non-adjacent cells that I want to average but throw out one of the numbers if one of them is zero...I used this and it works fine with adjacent cells but stumped on getting it to work with two non-adjacent cells. My cells are F3 and K3. =AVERAGE(IF(B2:C2<0,B2:C2," ")) CTRL+SHIFT+ENTER Thanks for any help I get on this... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another Average non-adjacent cells question...
Biff wrote: Hi! One way: =IF(COUNT(F3,K3)<1,"",SUM(F3,K3)/SUMPRODUCT(--(MOD(COLUMN(F3:K3),5)=1),--(F3:K30))) Biff wrote in message ups.com... I have two non-adjacent cells that I want to average but throw out one of the numbers if one of them is zero...I used this and it works fine with adjacent cells but stumped on getting it to work with two non-adjacent cells. My cells are F3 and K3. =AVERAGE(IF(B2:C2<0,B2:C2," ")) CTRL+SHIFT+ENTER Thanks for any help I get on this... Thanks that worked! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Cells above 0 | Excel Discussion (Misc queries) | |||
How do I average a range of cells when one cell contains #N/A | Excel Discussion (Misc queries) | |||
Average non-adjacent cells if the cell does not contain zero | Excel Discussion (Misc queries) | |||
Average Non-Continuous Cells Without Zero's | Excel Worksheet Functions | |||
Average If Question | Excel Discussion (Misc queries) |