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))))
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))))
Thanks. I think the first option would fit me best.
But when i past the formula I get the error below...
