When working with a database or dataset in Excel, often one wants to query the data set for values that are within a specific range. For example, what is the total amount outstanding for invoices that are between 30 and 60 days overdue? Sometimes this is implemented as two separate queries and the difference taken [...]