Extracting Number of lanes

[Joe Shaer]

Hello -

I am attempting to extract 'number of lanes' based on four criteria using the FILTER function. For some reason I keep getting a 'value' error and I don't know why. I am attaching a sample of the work. Hope someone can help.

Thanks
Joe

 

[bosco_yip]

Try, this formula instead with highlight red revised

In E3, formula copied down:

=FILTER($S$3:$S$223,IFERROR((B3=0+($K$3:$K$223))*(C3=$M$3:$M$223)*(D3>=$O$3:$O$223)*(D3<=$Q$3:$Q$223),0),0)

Regards