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.
Reputation: 16. Advertisements. We're planning a move to the Albuquerque area and are looking at property in the Tijeras or Cedar Crest area. However, everyone tells me that the weather there is very different from that on the other side of the mountain. I know that it's cooler, but does it get more rain and less sunny skies.