Frequency function

Question

I am using Microsoft 365 on Windows 10.

I can use the Frequency function to count the number of values that fall within a group of intervals. For example, I can produce a table showing the number of invoices that have been outstanding for one week or less, more than one week but not more than two weeks, more than two weeks but not more than three weeks, etc.

This is very useful information but is it possible to extend the functionality to return something other than the count? For example, the sum or average, such as the total value of receivables outstanding in each interval rather than just the count,

IOW, despite it's name, is it possible to use "Frequency" to aggregate something other than count?

I can manually go through and sum the individual intervals but this is very tedious and inefficient. Is the only other alternative to use a macro or VBA?Or is there some other built in functionality that can accomplish what I am trying to do?

Thanks for any insights,

Answer 1

Excel 365 Pro Plus with Power Pivot and Power Query.

Count days and sum amounts per customer per PO per interval.

Referred from today.

No formulas, no VBA macro.

With PivotChart and Slicers.

https://www.mediafire.com/file_premium/vb3aufzpaozj134/04_30_23.xlsx/file

https://www.mediafire.com/file_premium/zw6ktvcwcwbjvyg/04_30_23.pdf/file