IFS Statement

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?

Find more posts tagged with

Formulas

Support

Comments

Mike 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?

Paul F

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 Wilday

Glad I could help you out! Happy Smartsheeting.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.