| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Summing a column of Numbers
How do I sum a large column of numbers when some of the cells within the
column contain... #N/A in it. Thanks, FLKULCHAR |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
thanks
"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 |
|
#4
|
|||
|
|||
|
You're welcome!
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "FLKULCHAR" wrote in message ... thanks "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 |
|
#5
|
|||
|
|||
|
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 | |||
Linear Mode
