Forum Discussion
Scott255
Jun 22, 2023Copper Contributor
Fn to find all cells in a column with exactly same text, then sum adjacent cells of matches
I have a "database" of parts. For instance, Part number 001, 002, 003, 004, etc. The Part name (ex: 001) is in column A. Each Part number has a location column (column B), and a quantity Column (col...
Patrick2788
Jun 22, 2023Silver Contributor
A PivotTable is probably most sensible but here's a formula solution:
=BYROW(Part,LAMBDA(row,IF(COUNTIF(TAKE(Part,ROW(row)-1),row)=1,SUMIF(Part,row,Qty),"")))