If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need to return a value!
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 |
#2
|
|||
|
|||
Need to return a value!
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! -------------------- (Ms-Exl-Learner) -------------------- "Scott_goddard" wrote: 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 |
#3
|
|||
|
|||
Need to return a value!
=SUM(IF(ISNA(B1:J1),"",B1:J1))
as an array formula (Control Shift Enter) -- David Biddulph "Scott_goddard" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|