Melmillw82
New Member
- Joined
- Nov 14, 2017
- Messages
- 27
Please help i have to combine these 2 formulas each has the criteria I need just stuck on putting them together.
=SUM(COUNTIFS($P:$P,"<> / /",$D:$D,">="&$B9,$D:$D,"<="&$C9,$A:$A,$D$5))
And
=AND($T:$T>=EDATE($P:$P,-2),$T:$T<=EDATE($P:$P,2))
Any help most appreciated ?
=SUM(COUNTIFS($P:$P,"<> / /",$D:$D,">="&$B9,$D:$D,"<="&$C9,$A:$A,$D$5))
And
=AND($T:$T>=EDATE($P:$P,-2),$T:$T<=EDATE($P:$P,2))
Any help most appreciated ?
