Try this for C2 copied down

=SUMPRODUCT(((Data!$H$2:$H$10000>=$A2)*(Data!$H$2:$H$10000<=$B2)+(Data!$I$2:$I$10000>=$A2)*(Data!$I$2:$I$10000<=$B2)+(Data!$M$2:$M$10000>=$A2)*(Data!$M$2:$M$10000<=$B2)>0)*(Data!$K$2:$K$10000="N"))

and exactly the same for D2 except with added sum range

=SUMPRODUCT(((Data!$H$2:$H$10000>=$A2)*(Data!$H$2:$H$10000<=$B2)+(Data!$I$2:$I$10000>=$A2)*(Data!$I$2:$I$10000<=$B2)+(Data!$M$2:$M$10000>=$A2)*(Data!$M$2:$M$10000<=$B2)>0)*(Data!$K$2:$K$10000="N"),Data!$J$2:$J$10000)

see attached

regards, barry

26909642.xlsx

=SUMPRODUCT(((Data!$H$2:$H

and exactly the same for D2 except with added sum range

=SUMPRODUCT(((Data!$H$2:$H

see attached

regards, barry

26909642.xlsx