Results 1 to 7 of 7

Help with Sumif function please, need two criteria

Threaded View

  1. 05-02-2014, 05:35 PM #1
    JCarollo765
    JCarollo765 is offline
    Registered User
    Join Date
    04-22-2014
    Location
    San Diego
    MS-Off Ver
    Excel 2010
    Posts
    36

    Unhappy Help with Sumif function please, need two criteria

    Hi so I'm trying to calculate the gross pay percentage by department and person, but my sumif function is adding the total gross pay twice for different departments. I can't figure out how to have it look at two criteria instead of just one. I've attached a workbook with my problem thank you.
    Attached Files Attached Files
    Last edited by JCarollo765; 05-05-2014 at 12: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)

Similar Threads

  1. [SOLVED] SUMIF function for 2 criteria
    By stonecul in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-08-2014, 08:24 PM
  2. SUMIF criteria using the AND function
    By BobTheRocker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2011, 11:34 AM
  3. SUMIF function using Criteria on different worksheet
    By Taxed Mind in forum Excel General
    Replies: 2
    Last Post: 04-14-2006, 09:10 AM
  4. [SOLVED] Two Criteria in SumIf Function
    By Jack Gillis in forum Excel General
    Replies: 3
    Last Post: 11-15-2005, 01:00 PM
  5. Help with SUMIF function criteria
    By Marina in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2005, 09: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1