Combining Countif formula with an IF(AND formula

[willow1985]

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!

 

[DanteAmor]

How about:

=COUNTIFS(WOR[[#All],[W/O Number]],"<>",WOR[[#All],[Customer Exclusions]],"<>Exclude",WOR[[#All],[Date Received]],">="&GraphData!B13,WOR[[#All],[Date Received]],"<="&GraphData!B3)

 

[willow1985]

This appears to be exactly what I am looking for. I never thought to add it like this... Thank you very much!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.