Wikipedia:Reference desk/Archives/Computing/2012 April 15

Hi, does anyone know a simple way to create a Wikipedia:Most wanted articles-type list of most linked-to articles for another language version, specifically the Crimean Tatar Wikipedia? Here's the [http://dumps.wikimedia.org/crhwiki/ database dump], but I have no idea how to go from there. Lesgles (talk) 03:48, 15 April 2012 (UTC)

I want to sum a range of numbers, but I want the input to be controlled by another cell. I mean instead of say SUM(A1:A3) I want SUM(x, y), where x and y are cell positions that will have the details of the cells to be summed. 159.92.119.242 (talk) 18:45, 15 April 2012 (UTC)

:You can use =SUM(INDIRECT( X &":"& Y )), then in cells X and Y, put text that mentions the start and end cells you want. The & operator concatenates text. The INDIRECT function takes a piece of text and returns the cell reference mentioned in the text. --Bavi H (talk) 19:16, 15 April 2012 (UTC)