Multiple If formula

[PHIL.Pearce84]

HI,

I am trying to get a multiple if statement to work but I've lost myself in the confusion, can anyone help?

Basically this is what I want to achieve;

1. If the completion date in Column J falls within any of the date ranges on the sheet (start date in D END DATE in I)
2. And if the values in G3,f3,e3 and C3 (which will continue up to row 2000 G4,5 ETC) then return yes otherwise no


This is my formula;

=IF(AND(J:J>=D3,I3<=I:I,"YES"),IF(G:G=G3,"YES"),IF(F:F=F3,"YES"),IF(E:E=E3,"YES"),IF(C:C=C3,"YES"),"No"))

 

[PHIL.Pearce84]

Hi, thanks for you help!! The countif works nicely, the only issues is identifying if it's within the same date range, as it would be nice to be able to retrospectively identify missed opportunity.

Thank you everyone for your help on this I really appreciate it