| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding the values of a sorted column if some cells contain #N/A
I am looking to add the contents of a column. Some of the values contain
#N/A. The info was put into a data filter. Column A is the Name, Column B is the Year, and Column C is the Value. If I sort the data filed to only display 2007, I would like the total for this. Is there a way to add the all of the values in the column together, but ingnore the #N/A? example of entire sheet: Object 1 2007 2 Object 2 2008 #N/A Object 3 2007 #N/A Object 4 2006 1 Total 3 Example of desired: Object 1 2007 2 Object 3 2007 #N/A Total 2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct where cell values are the same in a sorted column | Excel Discussion (Misc queries) | |||
| move a row of data values to a column in sorted order | Excel Discussion (Misc queries) | |||
| First Value in Sorted Column is Not Sorted Properly | Excel Discussion (Misc queries) | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
Threaded Mode
