This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Add a new worksheet (Sheet3) to the Bike Sales_ Consolidated workbook. In Row 1, create two column headings: 2021 Average Cost and 2021 Average Revenue. In Cell A2, type (do not copy and paste) =AVERAGE( Then, with the cursor next to the open parenthesis, click on the browser tab that contains the BikeSales_2021 worksheet. Select the range of cells Q2:Q14. Return to the Bike Sales_ Consolidated workbook and press ENTER. I have tried couple of times, its saying "The formula in this cell contains an error. Please kindly help.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
You need to use parentheses. Try
=AVERAGE('https://d.docs.live.net/f2aee2c27e1a507f/[Bike_Sales_2021.xlsx]Sheet1'!$Q$2:$Q$14)
Oh thanks, it looks like this
=AVERAGE'https://d.docs.live.net/f2aee2c27e1a507f/[Bike_Sales_2021.xlsx]Sheet1'!$Q$2:$Q$14
What does the formula look like before you press Enter?