Help with complex formula structure

[willow1985]

I believe the formula falls apart at the end but was hoping someone could help me clean it up....

The formula is:

=COUNTIFS(WOR[[#All],[W/O Number]],"<>",WOR[[#All],[Customer Exclusions]],"<>Exclude",WOR[[#All],[Date Quoted]],"",WOR[[#All],[Warehouse Name]],"Work in Progress",($B$3-WOR[[#All],[Date Received]]),">"&5)

Basically it is to count all W/O Number if not blank
with condtions:
If Customer Exclusions do not equal the word "Exclude"
Is a Blank Cell in Date Quoted
Has a Warehouse Name with the text "Work in Progress"
And the current date (B3) - Date Received has a result greater than 5 days

I hope I am explaining this ok. I know it is a lot of conditions...

Thank you to anyone who can help with the structure. I can post a pic of the data if that helps or you can get an idea of it on another post of mine: Combining Countif formula with an IF(AND formula

Thank you!

Carla

 

[jasonb75]

It's not possible to manipulate the values in the count ranges, you need to reverse the adjustment in the criteria instead.

=COUNTIFS(WOR[[#All],[W/O Number]],"<>",WOR[[#All],[Customer Exclusions]],"<>Exclude",WOR[[#All],[Date Quoted]],"",WOR[[#All],[Warehouse Name]],"Work in Progress",WOR[[#All],[Date Received]],"<"&$B$3-5)

 

[willow1985]

Ah I see, I couldn't wrap my head around how to incorporate the last part. Thank you very much!