Count formula with multiple conditions

[apmi]

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

[BlindAlley]

I will take a look at this for you, and mock something up to post back.

PS: Did you look at the attachment instructions at the bottom of the posts.?

[BlindAlley]

I used these 3 formulas and 1 regular countif to meet your criteria.

=SUM(COUNTIFS(G40:G46,"<"&TODAY(),E40:E46,{"DIR17-1st"}))
=SUM(COUNTIFS(G41:G47,"<"&TODAY(),E41:E47,{"DIR17-1st";"DIR17-ANN"}))+COUNTIF(G41:G47,G35)
=COUNTIF(G41:G47,G35)+COUNTIFS(G41:G47,"<"&TODAY())

[apmi]

Your attachment doesn't make sense...

I'll try the formulas.

[FlameRetired]

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. ...

Hello apmi.

Try instead

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

[apmi]

Attachment attempt

[apmi]

Thank you!!!

[apmi]

Please see below foe my spreadsheet

[FlameRetired]

In C2 try

Please Login or Register  to view this content.

In N3 try

Please Login or Register  to view this content.

N4 and N5 are problems. N4 references column N which will return a circular reference error. N4 and N5 both are to test for dates. If you are not aware of it dates are numbers representing days elapsed starting at 1/1/1900. Today (8/2/2019) that number is 43679. The formatting is cosmetic. This means any number in columns N:O will qualify.

You will need to limit the range references in formula N4 and find a way to define what numbers (typically a number/date range) in both N and O.