+ Reply to Thread
Results 1 to 3 of 3

Add all X's on all sheets

  1. #1
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Add all X's on all sheets

    I have the name Matt in column B in different spots, example B15, B29, B63. In the cell in column C next to the columns that contain "Matt" in column B, some of them contain the value "X". I need to add all the X's in column C that have "Matt" in the column B next to it. I need to do this on all sheets.

    Example

    B12 = Matt
    C12 = X

    B13 = John
    C13 = X

    B14 = Matt
    C14 =

    B15 = Matt
    C15 = X

    The answer would be 2.

    I know if may have to do this for sheet1 and then add it to sheet2 and so on to get the total, unless there was a way to just add it in the formula where it does it for the entire workbook.

    Thanks for help

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Add all X's on all sheets

    G1 to G3 Cell

    Sheet1
    Sheet2
    Sheet3


    =SUMPRODUCT(--COUNTIFS(INDIRECT("'"&G1:G3&"'!B1:B100"),"Matt",INDIRECT("'"&G1:G3&"'!C1:C100"),"X"))

    Change the G1:G3 cells to your number of sheets count and mention the sheet names of that range


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Re: Add all X's on all sheets

    Awwesome. Thanks. Worked like a champ!!!!!!!!!!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 10-04-2013, 04:21 AM
  2. Replies: 17
    Last Post: 02-01-2013, 12:20 PM
  3. [SOLVED] Refreshing/Recalculating Sheets based on user input or switching between sheets
    By SonOfOdin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2012, 09:48 PM
  4. Replies: 2
    Last Post: 01-18-2012, 05:08 AM
  5. [SOLVED] Macro for filter on protected workbook that works for all sheets, no matter what sheets are named?
    By StargateFanFromWork in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2006, 02:35 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