IFS Statement

Paul FPaul F
edited 12/09/19 in Formulas and Functions
12/04/18 Edited 12/09/19

I have the following equation I am trying to get working: =COUNTIFS({Range 1}, =1, {Range 2}, IFERROR(YEAR(@cell), 0) = 2018, {Range 2}, IFERROR(MONTH(@cell), 0) = January, {Range 3}, OR(@Cell="", @Cell="")) The equation has worked in the past without the or statement at the end.  It was once looking for one value here, now I want it to look for multiples.  Is this possible?

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    I've always had trouble using OR or AND statements in Countifs. A simple solution would be to manually add an additional countifs to the end of the first one using the + sign. 

    =COUNTIFS({Range 1}, =1, {Range 2}, IFERROR(YEAR(@cell), 0) = 2018, {Range 2}, IFERROR(MONTH(@cell), 0) = January, {Range 3}, @Cell="")+countifs({Range 3}@Cell="")

    But what I don't quite get is why you are looking for duplicate blanks. Both of those OR statements are looking for the same thing. Is that intended? 

  • That was my fault, I was unclear on that.  I am looking for two different names, I just erased them from the equation.  That works, equations are long, but exactly what I was looking for.  Thanks!

  • Mike WildayMike Wilday ✭✭✭✭✭

    Glad I could help you out! Happy Smartsheeting. 

Sign In or Register to comment.