Forum Discussion
Solved
Sum last columns with value only
Hi, I would like to make a sum of the last 3 (variable B7) columns with a value per row. The problem is that I want to exclude the rows without the value -. In the example below green is th...
ITTWS As anticipated by HansVogelaar here are two possible E365 solutions.
In F2 and copy down:
=SUM(TAKE(FILTER(B2:E2,B2:E2<>"-"),,-$B$7))or one that spills the results in one go:
=BYROW(B2:E5,LAMBDA(a,SUM(TAKE(FILTER(a,a<>"-"),,-B7))))
May I clarify, you'd like to sum last N columns, or last N values in the row excluding "-"?
Other words, if B7 is 2, what shall be in F2, 25 or 15?