Solved

Formula request

Posted on 2014-09-09
2
75 Views
Last Modified: 2014-09-10
Need to know how to run a formula requesting when a certain region is found, what the gross margin % is in that tab, and accumulate them all in the formula and compute the "average" of them all.

Thanks,

Pete
Formula.xlsx
0
Comment
Question by:pedwards3
2 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40313696
Hi,

pls try

=AVERAGE('0114:0814'!R13)

Regards
0
 

Author Closing Comment

by:pedwards3
ID: 40314669
Sweet.

That was it.

Thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Win7/Excel 2016 crashing 1 272
Please  help me sort this (complete) 5 74
Excel Power Pivot - Aggregation 7 81
Add up columns with numbers in certain rows 9 27
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Viewers will learn various types of data validation for different data types in Excel 2013.
Video by: Zack
Viewers will learn about using Excel in a browser with Excel Online.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question