[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 86
  • Last Modified:

Formula request

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
Pete Edwards
Asked:
Pete Edwards
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try

=AVERAGE('0114:0814'!R13)

Regards
0
 
Pete EdwardsAuthor Commented:
Sweet.

That was it.

Thanks
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now