Forum Discussion

Jessica Marion's avatar
Jessica Marion
Copper Contributor
Apr 06, 2017
Solved

COUNTIFS and exclude a value

Hi,   I've been working on this all day and getting nowhere. I'm really hoping somebody can help me.   I've set up a summary sheet where I want to count how many of each value (1, 2 or 3) is in t...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 06, 2017

    And space before "Last FY"

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 06, 2017

Hello Jessica

 

Remove the space between < and >.

 

Jessica Marion's avatar
Jessica Marion
Copper Contributor
Apr 06, 2017

Thanks for responding.

 

I've tried that, and when I do, it just counts all the Tier 1's whether or not the Quarter column says "Last FY".

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Apr 06, 2017

    And space before "Last FY"

    • Jessica Marion's avatar
      Jessica Marion
      Copper Contributor
      Apr 06, 2017

      Oh my gosh that's it.  I thought I tried every combination of spaces vs no spaces, but I guess not!

       

      Thanks so much for ending my agony :)

       

      -Jessica

Resources