CountIFS OR with more than one range
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:
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.