Results 1 to 7 of 7

CountIfS not working as expected

Threaded View

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

    CountIfS not working as expected

    Hi,

    I am hoping someone can shed some light on what I am doing wrong within this formula. I am also trying to add aging 0-1day, 2-5 day, 6-10 day and over 10.

    I am using this formula to count:
    =COUNTIFS(general_report!O2:O281,"<=1",general_report!A1:A281,"=Incident", general_report!F1:F281,"=P1")

    When I use this formula I receive an error #VALUE! however if I break it up I the results are correct meaning.
    =COUNTIFS(general_report!O2:O281,"<=1",general_report!A1:A281,"=Incident") THIS WORKS

    =COUNTIFS(general_report!F1:F281,"=P1") THIS WORKS

    =COUNTIFS(general_report!O2:O281,"<=1",general_report!A1:A281,"=Incident", general_report!F1:F281,"=P1") THIS DOESN'T work. :/

    On a side note I am trying to figure out how to report on age the "Day's Open" if anyone can give me any tips in this area I would be very, very happy.

    Thanks,

    Ruth S.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Struggling with COUNTIFS function returning 0 when value expected
    By vbalearnerdriver in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-03-2014, 06:32 AM
  2. [SOLVED] countifs working on extended ranges and different sheets not working
    By etaf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2013, 02:23 PM
  3. [SOLVED] Countifs In Array Not Working As Expected, then Update question
    By jcaynes in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2013, 06:53 PM
  4. [SOLVED] Countifs array results not as expected, can anyone see why?
    By jason.b75 in forum Excel General
    Replies: 6
    Last Post: 07-15-2012, 01:45 PM
  5. For Each Statement not working as expected
    By Jacqui in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2005, 06:20 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