Formula Request - numerical and text

[ItalianPlatinum]

Hello - I am looking for an excel formula that will sum columns B-D, but the issue is B-D could present strictly text values so I am running into an issue of how to support the following 2 criteria

1. If any numerical value sum in Column E
2. if all non numerical in B-D then in column E present "No Change"

see below for example:

Activity	Condition 1	Condition 2	Condition 3	FORMULA NEEDED
Y	100	No change	No change	100
N	No change	No change	No change	No change
N	No change	No change	No change	No change
Y	No change	500	No change	500
N	No change	No change	No change	No change
Y	No change	No change	150	150

 

[Joe4]

Place this in cell E2 and copy down:

=IF(COUNTIF(B2:D2,"No Change")=3,"No change",SUM(B2:D2))

 

[ItalianPlatinum]

Thanks it is working. i have another similar formula needed but little different. ill create a new post for that.