• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extracting Number of lanes

Joe Shaer

New Member
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
 

Attachments

bosco_yip

Excel Ninja
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
 
Top