I want to sum of large three column in last 5 column out of total column.Sorry, I don't know Hindi.
I want to sum of highest three Value out of last 5 column from right to left in above example.
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
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)
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.84768.800 56.400 24.111 61.285 59.368 66.000 60.900 N N N 20.310 0.000