• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Average of averages

You are close Xeno! You just forgot to use commas and dont use [ instead use (


For example:

=MAX(Sum('2005-Q1:2005-Q4'!G3),Sum('2006-Q1:2006-Q4'!G3))
 
@Montrey

Hi!

But I spent 16 changing the { for the (

Regards!

PS: second SUM with !G3... hmmm... I don't like it.
 
I hang my head in shame. This 23 year old has a lot to learn. I want to send you my dashboards SirJb7 and see what you think. Unfortunately the data is sensitive so i'm not quite sure the best way to go about it.
 
Perfecto!!!!!! Thank you gentlemennnnn very helpful to me...yea not sure how my bosses would feel about me sharing on a forum but....don't we all have these problems lol.


Thanks guys...
 
@xenomorph8472

Hi!

Firstly, if they get to know that...

Secondly, glad you solved it. Thanks for your feedback and for your kind words too. Welcome back whenever needed or wanted.

Regards!


@Montrey

Hi!

Don't worry about http://chandoo.org/forums/topic/average-of-averages/page/2#post-23648

You still got 28 more to outperform... so, who knows!

About your dashboards, well, clean them a little, change sensitive data, and let's see.

Post your email here and I'll get back to you asap, so you can send them.

Regards!

PS: if you wish, you can edit your post later and clear email.
 
Right,


I just tell them I troubleshoot online lol...wasn't really sensitive, generally public information.


I'm beginning to learn the wealth of information available on forums, been on a fitness forum that has literally transformed my life..so thought I'd give an excel forum a try to "transform" my, um excel output...:p


Take care..I'll be back...
 
Hi, xenomorph8472!

Fitness, fitness, ... where did I see that word... once...? Don't remember.

Fitness forum? The only forum I know that sounds alike is the Need For Speed forum :)

BTW, don't miss giving a look at NFS - The Run...

Regards!
 
You must log in or register to reply here.
Back
Top