willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 886
- Office Version
- 365
- Platform
- Windows
I have been using 2 formulas to get the data I need from a spreadsheet and was wondering if there was a way to combine them?
The first formula is on the report itself:
=IF(AND([@[Date Received]]>=GraphData!$B$13,[@[Date Received]]<=GraphData!$B$3),"Yes","No")
in B13 and B3 I have to and From Dates: January 3, 2020 to May 25, 2020 (for example). This formula looks in the Date Received column and flags a "Yes" or a "No" if it falls in between this date range.
On another Sheet I have formula:
COUNTIFS(WOR[[#All],[W/O Number]],"<>",WOR[[#All],[Customer Exclusions]],"<>Exclude"),"")
This counts everything in W/O Number column that is not blank and any item in Customer Exclusions that does not have the word "Exclude"
On this Countif formula I would also like to count any Date Received that falls in between the specified date range above.
Currently I could add one more condition to the CountIf formula to count anything that says "Yes" in the column AM where I have the IF(AND formula But I do not want to do this.
I will be having a lot of conditions similar to this IF(AND one so it would make the spreadsheet a lot smaller if I could somehow combine the 2 formulas...
I hope I am being clear...
I attached a picture of the sheets, hope this helps.
Thank you to anyone who can help!
The first formula is on the report itself:
=IF(AND([@[Date Received]]>=GraphData!$B$13,[@[Date Received]]<=GraphData!$B$3),"Yes","No")
in B13 and B3 I have to and From Dates: January 3, 2020 to May 25, 2020 (for example). This formula looks in the Date Received column and flags a "Yes" or a "No" if it falls in between this date range.
On another Sheet I have formula:
COUNTIFS(WOR[[#All],[W/O Number]],"<>",WOR[[#All],[Customer Exclusions]],"<>Exclude"),"")
This counts everything in W/O Number column that is not blank and any item in Customer Exclusions that does not have the word "Exclude"
On this Countif formula I would also like to count any Date Received that falls in between the specified date range above.
Currently I could add one more condition to the CountIf formula to count anything that says "Yes" in the column AM where I have the IF(AND formula But I do not want to do this.
I will be having a lot of conditions similar to this IF(AND one so it would make the spreadsheet a lot smaller if I could somehow combine the 2 formulas...
I hope I am being clear...
I attached a picture of the sheets, hope this helps.
Thank you to anyone who can help!