countifs wrong value

  1. C


    I am trying to populate a unique count of the following conditions Column B is either a Cake or Cupcake Column C is not equal to No Column D is not equal to No Column E is not equal to Yes If all the above is true, I want my cell to display a count of people who satisfy all the above. So...
  2. G

    Countifs formula return wrong values

    Hi, I am using the Countifs function to count the number of times a customer (using their account number in the formula) has made a transaction in any given week. My formula looks like this (for purchases): =COUNTIFS('15-Aug-2010'!$C$3:$C$9072,'SMS...

Some videos you may like

This Week's Hot Topics