I am looking for help with a formula. Hopefully there is one out there. I have several columns Month, 1 Assigned to, 2 Assigned to, 3 Assigned to, 4 Assigned to, and Status. I need to count if it is in say month 1 and assigned to office in any of the Assigned to columns and the status is open. Is there a way to have the ifs and the ands and the or all in one formula? So my example should come up with a count of 3.