+ Reply to Thread
Results 1 to 7 of 7

CountIFS? Help Please

  1. #1
    Registered User
    Join Date
    01-18-2012
    Location
    Wigan, England
    MS-Off Ver
    Excel 2016
    Posts
    14

    CountIFS? Help Please

    Hi all,

    I've attached the example of how I'd like the formula to react, but everything I try doesn't seem to work.

    I'd like the formula to check delivery date column and if anything matches column G 'Reason' to column I 'Included Reason List' it does a 'count' of column F 'cases' into the yellow section. I'd like if possible column I, to add more reasons as time goes on.

    If any of this doesn't make sense I apologise and thank anyone in advance for their help.

    Thank you


    Thanks for everyones help, apologies if I misled anyone on here, I'm just looking for the count version of this formula, i tried just changing sum to count but it didn't work.

    Thanks
    Attached Files Attached Files
    Last edited by Wincanton0151; 01-17-2020 at 03:47 AM.

  2. #2
    Valued Forum Contributor BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,059

    Re: SUMIFS Help Please

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by BMV; 01-14-2020 at 10:19 AM.

  3. #3
    Registered User
    Join Date
    01-18-2012
    Location
    Wigan, England
    MS-Off Ver
    Excel 2016
    Posts
    14

    Re: SUMIFS Help Please

    Thanks so much

  4. #4
    Registered User
    Join Date
    01-18-2012
    Location
    Wigan, England
    MS-Off Ver
    Excel 2016
    Posts
    14

    Re: SUMIFS Help Please

    Hi,

    Sorry, quick one - I hope. How do you change this formula to a count of those terms rather than total cases, it doesn't have to look at the date just a total for each.

    Thanks

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,070

    Re: SUMIFS Help Please

    Wincanton0151, I let it slip the 1st time because you already had your answer, but...

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    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

  6. #6
    Registered User
    Join Date
    01-18-2012
    Location
    Wigan, England
    MS-Off Ver
    Excel 2016
    Posts
    14

    Re: SUMIFS Help Please

    I've changed the title thanks, sorry didnt mean to miss lead anyone.

    Thanks

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,270

    Re: CountIFS? Help Please

    No - the title still isn't good enough - sorry. It needs to explain what you are trying to do, NOT the function you think you need to do it. Try again.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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: 0
    Last Post: 08-22-2017, 03:49 PM
  2. [SOLVED] Sumifs formula without using sumifs....
    By blockbyblock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2017, 10:45 AM
  3. [SOLVED] If no SUMIFS matches, 1, otherwise the SUMIFS result...
    By JYTS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-04-2016, 07:39 PM
  4. sumifs vs. Application.WorksheetFunction.SumIfs
    By flooyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2016, 11:22 AM
  5. [SOLVED] Looking for something simpler than SUMIFS - SUMIFS
    By YAbdelaal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-27-2014, 10:38 AM
  6. SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result
    By haldavid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2013, 03:42 PM
  7. [SOLVED] Sumifs, problem with the formula: =sumifs(c10:c200,<=today(),0)
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 04:26 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