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

{| width = "100%"

|- ! colspan="3" align="center" | Computing desk |- ! width="20%" align="left" | < April 14 ! width="25%" align="center"|<< Mar | April | May >> ! width="20%" align="right" |Current desk > |}

Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.

April 15

"Most wanted articles" for Crimean Tatar Wikipedia

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 database dump, but I have no idea how to go from there. Lesgles (talk) 03:48, 15 April 2012 (UTC)

Excel help

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)