+ Reply to Thread
Results 1 to 2 of 2

SUMIF Assistance

Hybrid View

kschmit1 SUMIF Assistance 09-30-2016, 01:35 PM
FDibbins Re: SUMIF Assistance 09-30-2016, 01:56 PM
  1. #1
    Forum Contributor
    Join Date
    09-08-2016
    Location
    Buffalo, NY
    MS-Off Ver
    365
    Posts
    115

    SUMIF Assistance

    Hello,

    I'm having some difficulty getting what I think should be a SUMIF formula to render the results I am looking for (if I am off with the SUMIF I'm up for any solution.)

    In the example there are two tabs - one is ultimately a data dump and the other will be an individual's "dashboard"

    On the Rollup/Dashboard tab I am ultimately trying to do the following:

    1. In Column B -Total Holds: Count the # of documents processed by analyst per day (i.e. all documents completed 10/1/16 by Sally) Note: Each line entry is considered a single volume document

    2. In Column C - Total errors: Count the total number of errors by analyst per day (Error types are Columned E-N on tab 1, however no matter how many X's are in a row it should register as a count of 1 as it is only 1 document it just had multiple errors)

    For the example please assume tab 2 is for Sally only, not Mark.

    Any help is appreciated!
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: SUMIF Assistance

    For 1...
    B3=COUNTIFS(Example!$A:$A,'Rollup tab'!$A3,Example!$B:$B,"sally")
    copied down

    For 2...
    I added a helper column in Example sheet.
    O2=COUNTA(Table1[@[Exemption]:[Worksheet]])>0
    For the count...
    C2=COUNTIFS(Example!$A:$A,'Rollup tab'!$A3,Example!$B:$B,"sally",Example!$O:$O,TRUE)
    copied down
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. SumIf formula or Sumif with pivottable combined question
    By mcgleeuw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2015, 01:05 PM
  2. [SOLVED] SUMIF(INDIRECT Assistance
    By robertguy in forum Excel General
    Replies: 3
    Last Post: 03-12-2015, 09:11 PM
  3. [SOLVED] Shorten SUMIF + SUMIF + SUMIF each with same reference range but different criteria???
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2014, 09:25 PM
  4. Sumif Formula Assistance need to calculate vacation/illnes hours
    By J_Norris in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2013, 03:23 PM
  5. Replies: 1
    Last Post: 07-16-2012, 12:22 PM
  6. SUMIF Assistance...I think
    By freakadlibitur in forum Excel General
    Replies: 6
    Last Post: 04-20-2008, 12:59 PM
  7. Formula SUMIF assistance
    By TQB in forum Excel General
    Replies: 5
    Last Post: 01-24-2005, 07:55 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