| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
WOW!
Lots to learn here! Lou "RagDyer" wrote: Try this: =SUMIF(A:A,"<#N/A") -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "FLKULCHAR" wrote in message ... How do I sum a large column of numbers when some of the cells within the column contain... #N/A in it. Thanks, FLKULCHAR |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| Consecutive Numbers down a column not to Exceed 49 | Excel Worksheet Functions | |||
| column filtering to match identical numbers | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| add only positive numbers and avg in a column | Excel Worksheet Functions | |||
Hybrid Mode
