Solved

Formula request

Posted on 2014-09-09
2
63 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 48

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
In  today’s increasingly digital world, managed service providers (MSPs) fight for their customers’ attention, looking for ways to make them stay and purchase more services. One way to encourage that behavior is to develop a dependable brand of prod…
Viewers will learn what comprises a theme in Excel 2013, as well as how to customize them.
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now