Hello,

First off, somehow I cannot add my attachment. When I click on the attachment icon, a thin blank rectangle pops up but i can't click on anything. If you know how I can fix this, let me know and I will try again to add the spreadsheet.

I am adding a screen shot.

I need help with the following:

1. Cell C2 - I need the total count of everything in Column N and O that does not equal "exempt"

2. Cell N3 - I need the total count for everything in column O that does not equal "exempt" IF column M equals "DIR17-1ST"

3. Cell N4 - I need the total count for everything in Column N that equals a date or the term "Shut in" IF column M equals "DIR17-1ST" and "DIR17-ANN"

4. Cell N5 - I need the total count for everything in Column O that equeals a date or the term "Shut in"

Thank you so much! I can get the standard countif but when I try to add other conditions, it just spits back #N/A.Image 1.PNG