Results 1 to 7 of 7

Counting multiple cells over multiple worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    01-07-2015
    Location
    UK
    MS-Off Ver
    2016
    Posts
    7

    Counting multiple cells over multiple worksheets

    I have a workbook with multiple worksheets. One worksheet for each month.
    On each worksheet i have a list of initials in column A. In column B, is either 'In' or 'out'.

    I need to count which initial did how many ins or outs.

    I know I can use the filters, but i was thinking of something more along the lines of a drop down box that you select your initial and another where you select 'In' or 'Out', then it gives you a number.

    Please see attached file.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to sum the product of multiple cells across multiple worksheets
    By ciayers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2013, 03:28 PM
  2. [SOLVED] Macro to combine multiple cells from multiple worksheets into one worksheet
    By sharpmarc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-20-2013, 02:42 PM
  3. Copying multiple cells from multiple worksheets to one summary sheet
    By Dragothemensch in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-18-2013, 08:39 PM
  4. Counting Cells With Multiple Criteria on Multiple Sheets
    By ericmeiers in forum Excel General
    Replies: 5
    Last Post: 08-04-2012, 10:23 PM
  5. adding certain cells in multiple worksheets in multiple workbooks
    By Stephen via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2005, 05:06 PM

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