The following example uses one argument -- a reference to cells A1:A5. 1  Enter the sample data on your worksheet. 2  In cell A7, enter a AVERAGEA formula, to average the numbers in column A: =AVERAGEA(A1:A5) 3  Press the Enter key, to complete the formula.  The result will be 16.38, the average of the cells that contain data.
Tijeras, New Mexico. Tijeras is a village in Bernalillo County, New Mexico, United States. The population was 541 at the 2010 census. It is part of the Albuquerque Metropolitan Statistical Area.
Piedras Negras is located 441 km north of Saltillo via Federal Highway 57 in the State of Coahuila, Mexico. Piedras Negras is called La Puerta de Mexico (Mexico's Door) because of the flow of commercial traffic and people that passes through it. It is the sister city, across the Rio Grande, of Eagle Pass, Texas. Piedras Negras is well-known for its ranches where sportsmen can hunt species of high-class.