Forum Discussion
Summing data based on multiple criteria - Dynamic formula option?
Attached is a two tab data set representative of a problem I run into frequently. * The "Payroll Source" tab has financial information listed monthly in consecutive columns (i.e. 12 months = 12 colu...
I got as far as returning a 5x4 spilt range for each date.
= LET(
source, XLOOKUP(@DateHdr,SourceDate,sourceData),
SUMIFS(source,Department,DeptHdr,Division,DivHdr))As things stand, the formula would need to by copied 12 times. My goal would be to return the entire result as a single array formula but, even with the new Lambda functions, stitching the results together is likely to be a cumbersome process.