Thread: is sit possible to auto populate a cell based on dates
View Single Post
 
Old 11-27-2017, 09:41 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Does this work?

=IF(AND(B2="PAID",C2="E&M",SUMIFS($E$2:$E$21,$A$2: $A$21,A2,$C$2:$C$21,"PRE-OP")=E2+1),"Y","N")
Reply With Quote