| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return date if in range, else return blank | Excel Worksheet Functions | |||
| 11 becomes 12 after hit return | Excel Discussion (Misc queries) | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
