willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 888
- Office Version
- 365
- Platform
- Windows
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
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