# Counting multiple columns with multiple conditions

Options
✭✭✭✭✭✭

I have a working formula that counts if a task is not complete and due in a specific week:

=COUNTIFS([Calc if Done]@row, =0, [End Date]@row, AND(@cell > TODAY(+7), @cell <= TODAY(+14)))

This currently returns a 0 if false and 1 if true. Then can sum the Tasks due for particular week.

I need to add another condition to this formula that COUNTS if the Task Owner OR Additional Resource are any of 4 different possibilities. I'm struggling with how to do this one formula and thinking it would need to be parsed out into several different column/formulas. I have started breaking it down into several formulas and I am comfortable doing it that way. I'm looking for a cleaning (less columns and formulas) solution if possible.

Is it possible in one formula to determine for each row:

IF Calc if done = 0

AND End Date is between two dates

I HAVE THE FORMULA WORKING UP TO THIS POINT. I ALSO WANT THE FORMULA TO...

COUNTIF Task Owner OR Additional Resource = any of 4 different possibilities.

Hoping one of the genius formula folks can guide me on this one.

Thanks!!

Jeana