CountIFS OR with more than one range

edited 12/09/19 in Smartsheet Basics


I am running into some trouble trying to add an OR to a fairly complex CountIFs function. I have tried placing the OR at multiple points, but either get unparseable or invalid operation errors. Here is one attempt:

=COUNTIFS({Range 1}, "Color", {Range 2}, NOT(ISBLANK(@cell)), OR {Range 3}, NOT(ISBLANK(@cell)), {Range 4}, >TODAY(-90))

I am trying to identify the color in Range 1 and then count if the column in Range 2 OR Range 3 is not blank. Finally, I am looking for only those entries in the last 90 days.

Thanks in advance for any help.