Forum Discussion
Excel Formula Help
Hello! I need some help with formulas. I'm making an expense sheet and want to make a vertical column for "departments". Looking to create a formula that adds up the different departments in that sin...
Here's a solution using REDUCE:
Lambda
Summarize(a, v)
=LET(filtered, SUM(FILTER(val, dept = v)), VSTACK(a, HSTACK(v, filtered)))
Sheet Level formula:
=REDUCE({"Dept","Val"},UNIQUE(Dept),Summarize)