| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Averaging cells which contain #DIV/0!
This sounds like what I need, also. Except in my situation, the cells I need
to find the average of are not contiguous. "Domenic" wrote: Try... =AVERAGE(IF(ISNUMBER(A1:A10),A1:A10)) ...entered using CONTROL+SHIFT+ENTER. Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=271242 |
|
#2
|
|||
|
|||
|
maryj Wrote: This sounds like what I need, also. Except in my situation, the cells I need to find the average of are not contiguous. Which cells do you want to average? -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=271242 |
|
#3
|
|||
|
|||
|
E10,E13,E16,E19,E22. These values were all derived from a sumif.
"Domenic" wrote: maryj Wrote: This sounds like what I need, also. Except in my situation, the cells I need to find the average of are not contiguous. Which cells do you want to average? -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=271242 |
|
#4
|
|||
|
|||
|
Try the following array formulas, entered using CONTROL+SHIFT+ENTER... =AVERAGE(IF((MOD(ROW(E10:E22),3)=1)*(ISNUMBER(E10: E22)),E10:E22)) OR =IF(COUNT(E10,E13,E16,E19,E22),AVERAGE(IF((MOD(ROW (E10:E22),3)=1)*(ISNUMBER(E10:E22)),E10:E22)),"") Hope this helps! maryj Wrote: E10,E13,E16,E19,E22. These values were all derived from a sumif. "Domenic" wrote: maryj Wrote: This sounds like what I need, also. Except in my situation, the cells I need to find the average of are not contiguous. Which cells do you want to average? -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=271242 -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=271242 |
|
#5
|
|||
|
|||
|
That did it! Thanks!
"Domenic" wrote: Try the following array formulas, entered using CONTROL+SHIFT+ENTER... =AVERAGE(IF((MOD(ROW(E10:E22),3)=1)*(ISNUMBER(E10: E22)),E10:E22)) OR =IF(COUNT(E10,E13,E16,E19,E22),AVERAGE(IF((MOD(ROW (E10:E22),3)=1)*(ISNUMBER(E10:E22)),E10:E22)),"") Hope this helps! maryj Wrote: E10,E13,E16,E19,E22. These values were all derived from a sumif. "Domenic" wrote: maryj Wrote: This sounds like what I need, also. Except in my situation, the cells I need to find the average of are not contiguous. Which cells do you want to average? -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=271242 -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=271242 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| Averaging only cells with data | Excel Discussion (Misc queries) | |||
Linear Mode
