|
|
#1
01-11-2012, 11:39 AM
|
|||
|
|||
Sum Formula in the range with Numeric and NonNumeric data cells
I have a cell range that using a LOOKUP and =OFFSET(..,MATCH....). some of the values returned are #N/A, which is expected. I want to make u SUM to all cells in that range in the end of the column (that do not contain the result #N/A) but i can not!
|
|
#2
01-11-2012, 12:36 PM
|
||||
|
||||
|
Try =SUMIF(your_range,"<>#N/A",your_range)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
01-12-2012, 09:15 AM
|
||||
|
||||
|
Here's another way, similar to Peco's, which will ingore any error value:
Code:
=SUM(SUMIF(A2:A1000,{"<0",">0"}))
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to combine different cells data in one cell?
|
Learner7 | Excel | 1 | 07-28-2010 12:07 PM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
|
Cut and paste a range of cells and preserve formatting
|
StarWeaver | Excel | 1 | 03-02-2010 01:41 PM |
|
Moving formula range multiple cells when moving sum over one cell
|
FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |
|
Range Formula
|
aleksandr | Excel | 10 | 05-18-2009 12:14 PM |
Windows XP 
Office 2003
Linear Mode
