Results 1 to 4 of 4

CountIfS and SUMPRODUCT need help

Threaded View

rschoenb CountIfS and SUMPRODUCT need... 11-12-2014, 11:12 PM
Vikas_Gautam Re: CountIfS and SUMPRODUCT... 11-12-2014, 11:17 PM
rschoenb Re: CountIfS and SUMPRODUCT... 11-12-2014, 11:20 PM
boopathiraja Re: CountIfS and SUMPRODUCT... 11-12-2014, 11:21 PM
  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.

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