Need to return a value!

[Scott_goddard]

HI,

I have eight columns of data. Each cell either has N/A (returned from
another sheet) or a number, only one column will have a number. My question
is, how do i show the number in another column??


Current SalesP Total Cost (L)
24,595.00 #N/A 18628.18 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
718 #N/A 718.18 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
17,140.00 #N/A 17140.00 #N/A #N/A #N/A #N/A #N/A #N/A #N/A

 

[Ms-Exl-Learner]

Try this…

=SUMIF(B1:J1,"<>#N/A",B1:J1)

Change the cell reference of B1:J1 to your desired range, if required.

If this post helps, Click Yes!

 

[David Biddulph]

=SUM(IF(ISNA(B1:J1),"",B1:J1))
as an array formula (Control Shift Enter)