IF Formula

[eramirez148]

Is there a possible formula that will give me the following results in column A.
If the values from column B to column I are all zeros then the result should be zero. But if the values are higher than zero I want it to populate all the values except the zeros.

Column A	Column B	Column C	Column D	Column E	Column F	Column G	Column H	Column I
20, 19, 5, 8, 10	20​	19​	0​	0​	5​	8​	10​	0​
0​	0​	0​	0​	0​	0​	0​	0​	0​

 

[Peter_SSs]

With Peter's comment and the header, it would've been easier ..

Exactly why I asked the question about headers.

One thing I notice is that the result is not in numerical value ...

I wonder if you actually mean numerical order?

24 04 07.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Root causes Flagged	Number of instances product was out of stock	Root Cause	Initial Stock	Balance	Root Cause	Delivered Quantity against STO	Balance	Root Cause	STO Quantity	Balance	Root Cause	Store Order Forecast	Balance	Root Cause	Adjustments to available stock	Balance	Root Cause
2	10, 11, 12, 18	0	18	7209	0.47	10	32662	0.23	11	32662	0.23	0	32662	0.23	12	-687	0.21	0
3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Root Causes

Cell Formulas
Range	Formula
A2:A3	A2	=TEXTJOIN(", ",,SORT(FILTER(B2:R2,($B$1:$R$1="Root Cause")*(B2:R2<>0),0),,,1))

Not sure how many rows of data you have but another option with 365 is to use this formula in the first cell and all the results will fill down without having to copy the formula down.

24 04 07.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Root causes Flagged	Number of instances product was out of stock	Root Cause	Initial Stock	Balance	Root Cause	Delivered Quantity against STO	Balance	Root Cause	STO Quantity	Balance	Root Cause	Store Order Forecast	Balance	Root Cause	Adjustments to available stock	Balance	Root Cause
2	10, 11, 12, 18	0	18	7209	0.47	10	32662	0.23	11	32662	0.23	0	32662	0.23	12	-687	0.21	0
3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Root Causes (2)

Cell Formulas
Range	Formula
A2:A3	A2	=BYROW(B2:R3,LAMBDA(r,TEXTJOIN(", ",,SORT(FILTER(r,(B$1:R$1="Root Cause")*(r<>0),0),,,1))))
Dynamic array formulas.

And if you comment was not about putting the values in numerical order, the "spill down" formula would be

=BYROW(B2:R3,LAMBDA(r,TEXTJOIN(", ",,FILTER(r,(B$1:R$1="Root Cause")*(r<>0),0))))