Closed Thread
Results 1 to 3 of 3

Counting between worksheets

Hybrid View

  1. #1
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Counting between worksheets

    In Worksheet2, create a helper column in E with the formula =A2&D2 in E2, then drag this down the list.

    Then in Sheet1, cell B2 put the following formula

    =COUNTIF(Worksheet2!$E:$E,Worksheet1!$A2&Worksheet1!B$1)
    drag this along and down to fill the matrix

    and that should be that

    How it works:
    Column E creates a single identifier showing both the basket and fruit such as Basket1Orange, Basket1Apple, Basket6Banana etc

    The matrix then uses COUNTIF to see how many of each there are in Column E and what to search for by taking the column A value and adding the row 1 value for each item so in cell D10 its looking for A10 (Basket9) and D1 (Banana) giving a search value of "Basket9Banana"
    Last edited by pjwhitfield; 12-09-2014 at 03:25 PM.
    If someone has helped you then please add to their Reputation

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting between worksheets
    By joeyga in forum Excel General
    Replies: 3
    Last Post: 12-09-2014, 03:58 PM
  2. Conditional counting between worksheets
    By skidia in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-30-2013, 12:53 PM
  3. [SOLVED] Counting worksheets with a particular name
    By Freddie Mac in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-30-2006, 08:45 AM
  4. [SOLVED] Counting across worksheets
    By Pelham in forum Excel General
    Replies: 2
    Last Post: 08-17-2005, 05:05 AM
  5. [SOLVED] Help with counting across worksheets
    By Biff in forum Excel General
    Replies: 4
    Last Post: 04-12-2005, 12:06 AM

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