+ Reply to Thread
Results 1 to 4 of 4

CountIfS and SUMPRODUCT need help

  1. #1
    Registered User
    Join Date
    11-11-2014
    Location
    United States
    MS-Off Ver
    MS Office 2013
    Posts
    37

    CountIfS and SUMPRODUCT need help

    Ok this seemed easy until it didn't work. :/

    I have a column with numbers varying in values. I need to count the numbers that are greater, equal or less then specific numbers like "<=1" this one was easy. However when I try ">=2,<5" that doesn't work with count it. I could use sumproduct but I have other criteria I am checking.

    =COUNTIFS(general_report!O2:O281,">=2,<5",general_report!A2:A281,"=Incident", general_report!F2:F281,"=P1")

    How can I count the number between but look for the two criteria as well?

    =SUMPRODUCT((O2:O281>=0)*(O2:O281<=1))
    =SUMPRODUCT((O2:O281>=2)*(O2:O281<=5))

    but that will grab everything and not look at other criteria "=Incident" and "=P1" like I need it to. Is there a way to work around this?

    Thanks!
    Last edited by rschoenb; 11-12-2014 at 11:14 PM.

  2. #2
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: CountIfS and SUMPRODUCT need help

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

    Regards,
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  3. #3
    Registered User
    Join Date
    11-11-2014
    Location
    United States
    MS-Off Ver
    MS Office 2013
    Posts
    37

    Re: CountIfS and SUMPRODUCT need help

    That worked thank you very much!

  4. #4
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: CountIfS and SUMPRODUCT need help

    Hi, try this

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click just below left if it helps, Boo?ath?

+ 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. [SOLVED] Sumproduct/countifs
    By mahat in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-21-2014, 10:30 PM
  2. COUNTIFS and SUMPRODUCT help
    By Stacy1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-19-2013, 02:35 PM
  3. CountIFS and SUMPRODUCT Combined??
    By nobodyukno in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2013, 01:59 PM
  4. Convert CountIFs into SumProduct
    By gingank in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2012, 09:25 PM
  5. Using SUMPRODUCT instead of COUNTIFS
    By SymphonyTomorrow in forum Excel General
    Replies: 12
    Last Post: 11-18-2011, 05:01 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