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 between them. However, it can in fact be implemented as a single query.
To implement as a single query when using the SUMIFS function, one simply tests the same criteria range twice within the same function evaluation i.e. summing the amounts overdue by testing within the “overdue range” when the criteria >30 is met, and then (as an additional argument to the same function) testing again within the “overdue range” whether the criteria <=60 is met. [Read more…] about Implementing a Between Query with SUMIFS or DSUM