+ Reply to Thread
Results 1 to 2 of 2

SUMIFS with a greater than or equal to, as well as an OR criteria

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    East Riding of Yorkshire
    MS-Off Ver
    Excel 2010
    Posts
    16

    SUMIFS with a greater than or equal to, as well as an OR criteria

    Hi

    I am going insane trying to figure out my SUMIFS formula and I am looking for any help please! I have a job tracker which is an intergral part of keeping track of what jobs are costing us and the profit for each one, however I am trying to tally it up with our accounts on a monthly basis. So I have added in a date at the top so that at any date I choose, April, May or June, I can see how our job tracker should have looked at this point in time. The only part I am struggling with is the part where we need to work out our accrual, i.e. we haven't received an invoice at the month end relating to a job in that month (apologies if this sounds patronising), so we need to put in a figure so that our accounts for that month show an accurate picture.

    My problem is that where we have received an invoice later in the year the below formula works, however, if we still have not received an invoice therefore rather than a date to lookup there is just a blank it returns zero rather than the expected figure. I need to work out how to put an OR statement to look up for invoices which have been received later on in the year but also for a blank - i.e. still no invoice received.

    It currently looks like this:
    =IF($C6="Invoice",SUMIFS(Costs!H:H,Costs!A:A,B6,Costs!K:K,">"&$B$2,Costs!B:B,"Invoice"),SUMIFS(Costs!I:I,Costs!A:A,B6,Costs!K:K,">"&$B$2,Costs!B:B,"Credit"))

    Thank you, any help will be greatly appreciated as I am currently banging my head against a brick wall here!

    Faye

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: SUMIFS with a greater than or equal to, as well as an OR criteria

    A sample workbook would be needed to give more specific information rather than just how to apply an OR statement.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ 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. SumIfs containing a greater than or equal to And less than or equal to
    By teton88 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-15-2014, 07:47 PM
  2. [SOLVED] SUMIFS greater than or equal
    By telton in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-11-2013, 04:55 AM
  3. Sumifs Criteria, less than, greater than
    By telton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2013, 10:27 AM
  4. [SOLVED] Sumifs() with a greater/less than criteria?
    By bauerbach in forum Excel General
    Replies: 3
    Last Post: 06-14-2012, 01:58 PM
  5. [SOLVED] criteria for a given date equal or -greater then-
    By J_J in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-22-2005, 05:06 AM

Tags for this Thread

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