Hi i searched thru the forum but could not find any reference to my specific question.
I want the 5 lowest values in a row. The cells in the row may or may not have values. When i use the =SMALL function it thinks my blank cell is one of 5 smallest.
=SUM(SMALL(G4:U4,{1,2,3,4,5})) is the formula in the cell below with value=153. It is summing the 5 lowest values,
It is summing the 5 cells with the "X" above them. How do i skip the blank cell in YELLOW? BTW, each of these colored cells contain a vlookup formula.
G4---------------------------------------------------------------------------------U4
x x x x x
<tbody>
</tbody>
I want it to pick up these 5 values, 40, 40, 38, 39, 36
x x x x x
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
<tbody>
</tbody>
any ideas?
I want the 5 lowest values in a row. The cells in the row may or may not have values. When i use the =SMALL function it thinks my blank cell is one of 5 smallest.
=SUM(SMALL(G4:U4,{1,2,3,4,5})) is the formula in the cell below with value=153. It is summing the 5 lowest values,
It is summing the 5 cells with the "X" above them. How do i skip the blank cell in YELLOW? BTW, each of these colored cells contain a vlookup formula.
G4---------------------------------------------------------------------------------U4
x x x x x
153 | 14 | 4 | -5.4 | -5 | 40 | 40 | 40 | 40 | 40 | 38 | 45 | 49 | 51 | 43 | 41 | 52 | 39 | 36 |
<tbody>
</tbody>
I want it to pick up these 5 values, 40, 40, 38, 39, 36
x x x x x
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
153 | 14 | 4 | -5.4 | -5 | 40 | 40 | 40 | 40 | 40 | 38 | 45 | 49 | 51 | 43 | 41 | 52 | 39 | 36 |
<tbody>
</tbody>
153 | 14 | 4 | -5.4 | -5 | 40 | 40 | 40 | 40 | 40 | 38 | 45 | 49 | 51 | 43 | 41 | 52 | 39 | 36 |
<tbody>
</tbody>
any ideas?