countif Double count RRS feed

  • Question

  • I want to count a group of data with results across 12 cells (MONTHS). My problem as shown below counts "Torque Wrench" data twice. I tried to inject '<>"Torque Wrench"' but this was not liked by excel. Below is the countifs for April.

    =COUNTIFS(Status,"Active",Line,"M200",Class,"Torque Wrench",Mo1_4,"4")+COUNTIFS(Status,"Active",Line,"M200",Dept,"Assembly",Mo1_4,"4")

    Jim Neely

    Friday, May 11, 2012 2:54 PM


All replies

  • I don't really understand, but the condition for "not equal to Torque Wrench" would be

    "<>Torque Wrench"

    Regards, Hans Vogelaar

    Friday, May 11, 2012 3:16 PM
  • yes that did it. I had the <> outside of the quotes.

    Jim Neely

    • Marked as answer by STARFALLS Friday, May 11, 2012 3:52 PM
    Friday, May 11, 2012 3:52 PM