sum formula

[iullausha]

I want to sum of large three column in 5 column ou of total column.

1998-99	1999-2000	2000-01	2001-02	2002-03	2003-04	2004-05	2005-06	2006-07	2007-08	2008-09
56.923	54.540	N	60.285	N	59.368	60.900	68.800	61.047	66.000	24.111

 

[fjns]

Hi, it would be nice to see an example of exactly what you mean.

 

[iullausha]

You know hindi

 

[fjns]

Sorry, I don't know Hindi.

 

[iullausha]

Sorry, I don't know Hindi.

I want to sum of large three column in last 5 column out of total column.

 

[iullausha]

1998-99	1999-2000	2000-01	2001-02	2002-03	2003-04	2004-05	2005-06	2006-07	2007-08	2008-09
56.923	54.540	N	60.285	N	59.368	60.900	68.800	61.047	66.000	24.111

I want to sum of highest three Value out of last 5 column from right to left in above example.

 

[fjns]

Hi, see the linked file for a possible solution...

The formula used in the table...
L2: =SUM(G2:K2)-SMALL(G2:K2,1)-SMALL(G2:K2,2)

Sum_3_5.xlsx

 

[iullausha]

1998-99	1999-2000	2000-01	2001-02	2002-03	2003-04	2004-05	2005-06	2006-07	2007-08	2008-09
56.923	54.540	N	60.285	N	59.368	60.900	68.800	61.047	66.000	24.111	195.847​
68.800	56.400	24.111	61.285	59.368	66.000	60.900	N	N	N	20.310​	0.000​

 

[iullausha]

1998-99	1999-2000	2000-01	2001-02	2002-03	2003-04	2004-05	2005-06	2006-07	2007-08	2008-09
56.923	54.540	N	60.285	N	59.368	60.900	68.800	61.047	66.000	24.111	195.847​
68.800	56.400	24.111	61.285	59.368	66.000	60.900	N	N	N	20.310​	0.000​

This formula is ok, but it is not selecting the whole row from A2 to K2 (1998-99 to 2008-09)

 

[fjns]

Hi, I created a new table in which we add the 3 largest numbers from column A to column K.

The formula used in the new table...
L2: =IFERROR(LARGE(A2:K2,1),0)+IFERROR(LARGE(A2:K2,2),0)+IFERROR(LARGE(A2:K2,3),0)

Sum_3.xlsx