Adding Multiple low values
I am familiar with the min function, but I need to add two low values in a range. Example, If I have a range of four values (5, 4, 6, 5), how do i write the formula to add only the two lowest scores. In the example, the result of the formula would need to be 9 (4 & 5). thanks -- jdp554 ------------------------------------------------------------------------ jdp554's Profile: http://www.excelforum.com/member.php...o&userid=28185 View this thread: http://www.excelforum.com/showthread...hreadid=477160 |
Adding Multiple low values
Hi
Try the SMALL() function =SUM(SMALL(A1:A4,{1,2})) The figures inside the curly braces {1,2) tell the formula to take the 1st (smallest) and the 2nd. Regards Roger Govier jdp554 wrote: I am familiar with the min function, but I need to add two low values in a range. Example, If I have a range of four values (5, 4, 6, 5), how do i write the formula to add only the two lowest scores. In the example, the result of the formula would need to be 9 (4 & 5). thanks |
Adding Multiple low values
=SMALL(A:A,1)+SMALL(A:A,2)
Vaya con Dios, Chuck, CABGx3 "jdp554" wrote: I am familiar with the min function, but I need to add two low values in a range. Example, If I have a range of four values (5, 4, 6, 5), how do i write the formula to add only the two lowest scores. In the example, the result of the formula would need to be 9 (4 & 5). thanks -- jdp554 ------------------------------------------------------------------------ jdp554's Profile: http://www.excelforum.com/member.php...o&userid=28185 View this thread: http://www.excelforum.com/showthread...hreadid=477160 |
All times are GMT +1. The time now is 06:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com