Help needed in formula IF

[suciulaurentiu]

Good day! I need your help to figure out how to display the following:

I have several input dynamic cells like which can be varibles. I need a formula that sums up everything and tells me the only value text which is different than 0.

100 E
0
0
0
0

or

0
0
300 E
0
0


Thank you a lot!

 

[suciulaurentiu]

Good day! I need your help to figure out how to display the following:

I have several input dynamic cells like which can be varibles. I need a formula that sums up everything and tells me the only value text which is different than 0.

100 E
0
0
0
0

or

0
0
300 E
0
0


Thank you a lot!

Perhaps this one ? =INDEX(.......;MATCH(TRUE;INDEX(......<>0;0))

 

[jtakw]

Hi,

Does the cell Actually contain a Text, e.g. "100 E" or "300 E" , etc.

 

[suciulaurentiu]

Hi,

Does the cell Actually contain a Text, e.g. "100 E" or "300 E" , etc.

Yes, exactly, i belive i found what i was looking for, thank you!

 

[jtakw]

Yes, exactly, i belive i found what i was looking for, thank you!

Ok, glad you found what you're looking for.

If the non-zero value is TEXT, just in case, you can do this:

Book3.xlsx
	A	B
1	100 E	0
2	0	0
3	0	300 E
4	0	0
5	0	0
6
7	100 E	300 E
Sheet949

Cell Formulas
Range	Formula
A7:B7	A7	=LOOKUP("zzz",A1:A5)