+ Reply to Thread
Results 1 to 4 of 4

Cont.se with several tables

  1. #1
    Forum Contributor
    Join Date
    10-31-2008
    Location
    Brazil
    MS-Off Ver
    Office 365
    Posts
    108

    Question Cont.se with several tables

    Hi,

    I have a worksheet with 301 sheets and a lot of number. On column K I want to count how many cells are bigger than the number 7675.

    I use Cont.se("Table1:Table301'!K3:K800;">7675").

    But I got an error. I tested with a few tables and same problem.

    I attached a small file with 7 tables so you can see. The original table has 29 Mb.
    Attached Files Attached Files
    Last edited by douglascaixeta; 05-20-2010 at 02:22 AM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Cont.se with several tables

    The English formula you want is:

    Please Login or Register  to view this content.
    see if the attached translates it when opening it.

    I believe the Portuguese translation is:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by NBVC; 05-19-2010 at 10:42 PM.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Contributor
    Join Date
    10-31-2008
    Location
    Brazil
    MS-Off Ver
    Office 365
    Posts
    108

    Talking Re: Cont.se with several tables

    Thank you very much.

    I forgot to translate my formulation

    I tried but I don't understand what you did. But it works!

    If you have time, please explain to me.

    Thanks.

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Cont.se with several tables

    NBVC won't be on line for a while yet but in basic terms:

    Please Login or Register  to view this content.
    the above creates references to 'Table 2'!K3:K832, 'Table 3'!K3:K832 through to 'Table 17'!K3:K832... LIN is used to increment the Table reference from 2 to 17.

    The COUNT.SE is applied to each sheet individually:

    Please Login or Register  to view this content.
    The 16 COUNT.SE results are both generated and aggregated via the ecompassing SOMARPRODUTO call

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1