I would like to utilize the dynamic array functionality and create a formula that calculates the sum based on two criteria.
The formula that I have in N3 = SUM(FILTER(FILTER(H3#,H2#=N2),(G3#=M3))). Is there a way to make this spill down and to the right?
I have Office 365, but do not have the LAMBDA function.
test_sheet.PNG
Thanks!
Bookmarks