formula question

[hhamlinwright08]

Hi all,

I need help writing a formula for column 'W'.
If Columns U and V contain numbers, I would like column W to display the sum value.
If, however, columns U and V contain 'NA', I would like column W to also display 'NA'

Please see image below. Any help much appreciated!

 

[Toadstool]

Hi HHamlinWright08,

You don't say what to do if one is a number or if it contains something other than "NA". Maybe this works?

Book1
	U	V	W
1	LeftEye	RightEye	TotalScore
2	2	4	6
3	4	1	5
4	NA	NA	NA
Sheet1

Cell Formulas
Range	Formula
W2:W4	W2	=IF(ISNUMBER(U2/V2),SUM(U2:V2),"NA")

 

[hhamlinwright08]

Hi, thank you for the quick response!
Nearly perfect, however when using this formula if columns 'U' and 'V' both are 0, column 'W' becomes NA, when I would want it to be 0 also (as below)

If column U is 'NA' then column V can only every be 'NA' also.

I hope this makes sense!

 

[Toadstool]

How about

HHamlinWright08.xlsx
	U	V	W
1	LeftEye	RightEye	TotalScore
2	2	4	6
3	4	1	5
4	0	0	0
5	NA	NA	NA
Sheet1 (2)

Cell Formulas
Range	Formula
W2:W5	W2	=IF(U2&V2="NANA","NA",SUM(U2:V2))

 

[hhamlinwright08]

That's perfect, thank you very much!