C chris Feb 20, 2004 #1 i need to add a column of numbers but have to omit the 3 lowest numbers. how would i do this?
F Frank Kabel Feb 20, 2004 #2 Hi one way: =SUM(range) - SMALL(range,1) - SMALL(range,2)- SMALL(range,3) or =SUMIF(range,">" & SMALL(range,3)) though this can cause problems if you have duplicate values for the lowest 3 numbers
Hi one way: =SUM(range) - SMALL(range,1) - SMALL(range,2)- SMALL(range,3) or =SUMIF(range,">" & SMALL(range,3)) though this can cause problems if you have duplicate values for the lowest 3 numbers
C Cecilkumara Fernando Feb 20, 2004 #4 Chris, try this formula =SUM(H3:H21)-SUM(SMALL(H3:H21,{1,2,3})) change H3:H21 to suit your range HTH Cecil
Chris, try this formula =SUM(H3:H21)-SUM(SMALL(H3:H21,{1,2,3})) change H3:H21 to suit your range HTH Cecil
