Results 1 to 3 of 3

SumIF with two arguments

Threaded View

  1. #1
    Registered User
    Join Date
    12-15-2015
    Location
    Gotham City
    MS-Off Ver
    2013
    Posts
    8

    Red face SumIF with two arguments

    Dear Excel Forum,

    I am once again faced with the situation that only you can help me!
    What I need is a solution that picks up a value if: Col B = "Sep" & Col C = "Penalty".

    Currently I just have a sumIf function that gets the totals from the columns, but i need it to be allocated to the correct month.
    It might just be a matter of nesting the sumIf functions in a neat way?

    Please find the spreadsheet with further explanation kindly attached.

    Many Thanks!
    Pete
    Attached Files Attached Files
    Best Regards,

    Peter

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [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
  2. Sumif with index and match is returning too many arguments
    By jollyfella in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-02-2014, 10:45 AM
  3. [SOLVED] Countif/sumif too many arguments :d
    By rlowe in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-04-2013, 10:30 PM
  4. How to Sumif with multiple arguments
    By GSmith8 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-17-2013, 01:40 PM
  5. Arguments in a SUMIF function
    By andrewc in forum Excel General
    Replies: 2
    Last Post: 09-04-2009, 03:59 AM
  6. SumIf with 2 arguments
    By Snuker in forum Excel General
    Replies: 4
    Last Post: 07-18-2009, 09:52 AM
  7. Can I use two arguments for sumif?
    By ayang_008 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-05-2008, 11:40 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