• 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.

Consolidate Issues

I've looked over every tutorial and help file I can and no luck.


I'm trying to consolidate information (three functions: averages, max, min) and, upon executing the consolidate, the number in summary sheet always remains the same as the data in the first worksheet. I've only named the first four worksheets (as, of course, I'll need all worksheets calculated ultimately) in the 2nd column.


https://docs.google.com/open?id=0B15c6eYowyduUV91OF84LXFZazQ
 
Hi, xenomorph8472!


In Summary Sheet Cell E3 type:

=MAX('2004-Q1:2011-Q4'!C3)

And check if it's the desired result.


Regards!
 
Hi, xenomorph8472!

Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.

Regards!
 
Back
Top