Hii
=SUM(FILTER('Tax Invoice'!G:I,'Tax Invoice'!B:B=B7))
I want to spill the output of the above formula..
I tried following solution but no success:
=SUM(FILTER('Tax Invoice'!G:I,'Tax Invoice'!B:B=B7#)) (since B column contains a spilled array)
=BYROW(B7#,LAMBDA(x,SUM(FILTER('Tax Invoice'!G:I,'Tax Invoice'!B:B=x))))
pls help
Bookmarks