So here is my issue, in the attached spreadsheet, under the "Remedies" tab in Cell B3 I have my countifs formula. I am asking the formula to search for any instances between the dates of April 1 & April 30 that are in the tabs labeled "AJB, DMB, FTO, JJLK, KRA & TCM" and have the verbiage "Correspondence: Apology". But because the countifs formula needs all the criteria to be met before it will count, this is where I'm snagged. I need the formula to count how many instances of "Correspondence: Apology" appear in any of the tabs if the Date Closed is between April 1 & April 30th. How can I adjust my formula to do this?