Results 1 to 20 of 20

reference multiple sheets

Threaded View

the6thplague reference multiple sheets 10-12-2009, 04:19 PM
DonkeyOte Re: refrencing to multiple... 10-12-2009, 04:30 PM
the6thplague Re: refrencing to multiple... 10-12-2009, 04:43 PM
JBeaucaire Re: refrencing to multiple... 10-12-2009, 05:05 PM
JBeaucaire Re: refrencing to multiple... 10-12-2009, 05:15 PM
the6thplague Re: refrencing to multiple... 10-12-2009, 05:28 PM
the6thplague Re: refrencing to multiple... 10-12-2009, 05:33 PM
the6thplague Re: refrencing to multiple... 10-12-2009, 05:37 PM
JBeaucaire Re: refrencing to multiple... 10-12-2009, 05:32 PM
JBeaucaire Re: refrencing to multiple... 10-12-2009, 05:50 PM
the6thplague Re: refrencing to multiple... 10-13-2009, 02:05 AM
JBeaucaire Re: refrencing to multiple... 10-13-2009, 08:15 AM
the6thplague Re: refrencing to multiple... 10-13-2009, 10:15 AM
JBeaucaire Re: reference multiple sheets 10-13-2009, 11:29 AM
the6thplague Re: reference multiple sheets 10-14-2009, 07:30 AM
JBeaucaire Re: reference multiple sheets 10-14-2009, 08:29 AM
the6thplague Re: reference multiple sheets 10-14-2009, 02:07 PM
JBeaucaire Re: reference multiple sheets 10-14-2009, 04:16 PM
the6thplague Re: reference multiple sheets 10-14-2009, 06:29 PM
JBeaucaire Re: reference multiple sheets 10-14-2009, 07:05 PM
  1. 10-12-2009, 04:19 PM #1
    the6thplague is offline
    Registered User
    Join Date
    10-12-2009
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    12

    reference multiple sheets

    hi,
    I have an excel file with a lot of sheets in it. One sheet is named "main" and the other ones are named: 1, 2, 3, 4, 5, etc...

    I want to put the following function in the "main" sheet:

    =COUNTIF('1'!M2:M23,B1 & A2) + COUNTIF('2'!M2:M23,B1 & A2) + COUNTIF('3'!M2:M23,B1 & A2) + etc...

    The question is, is there a way to somehow tell excel to run the function to sheets 1 to 31 without typing a very very long function like above?

    Thanks a lot.
    Eyal.
    Last edited by the6thplague; 10-14-2009 at 06:30 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1