#1
|
|||
|
|||
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
|
||||
|
||||
Try =SUMIF(your_range,"<>#N/A",your_range)
__________________
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
|
||||
|
||||
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 |