Formula help combining and counting two conditional columns

AnneSh

Please help! I am Trying to count the total number when criteria is meet between two different columns. Each column has more than one answer option to include. Priority column can be answered Highest and or 5, Status Column can be answered either new or to do. Here is my formula among multiple others I have tried with no success. I also tried using a + in the equation as well and was unsuccessful.

Both columns need to include at least one of the answer options in order to include in the count;

=COUNTIF({SheetA|Priority}, OR(@cell = "Highest", @cell = 5), AND({SheetA|Status}, OR(@cell = "New", @cell = "To Do",)

Thanks!

Nic Larsen

Try:

=COUNTIFS({SheetA|Priority}, OR(@cell = "Highest", @cell = 5), {SheetA|Status}, OR(@cell = "New", @cell = "To Do")

AnneSh

Perfect! This works, thanks so very much Nic!!!