Forum Discussion
PTP3003
Jan 17, 2023Copper Contributor
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...
OliverScheurich
Jan 17, 2023Gold Contributor
With Office 365 or Excel 2021 or Excel for the web you can try this:
=HSTACK(SORT(UNIQUE(C1:C9)),BYROW(SORT(UNIQUE(C1:C9)),LAMBDA(row,SUMIF(C1:C9,row,D1:D9))))