Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Formula request

Posted on 2014-09-09
2
Medium Priority
?
84 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:Pete Edwards
2 Comments
 
LVL 53

Accepted Solution

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

pls try

=AVERAGE('0114:0814'!R13)

Regards
0
 

Author Closing Comment

by:Pete Edwards
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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.

782 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