I have a spreadsheet setup that records mistakes on orders. In one column it has the order number of the mistake as it is logged on a second sheet I have the order ranges that have gone out. I need a forumla that will check the column that has the order number for the mistake order and see if it is between the order ranges on the other sheet then count how many mistakes there are.
Example:
Sheet1
A1
123456
123457
123458
123459
123460
Sheet 2
A1 B1
123450 123456
123457 123459
So the output from the formula would show 4
Any help you can give would be much appreciated. Also this is in google spreadsheets but I figure the formula should be pretty similar.
Bookmarks