Sum Formula in the range with Numeric and NonNumeric data cells

		Microsoft Office Forums > Microsoft Excel > Excel
Sum Formula in the range with Numeric and NonNumeric data cells

FAQ

Thread Tools

Display Modes

01-11-2012, 11:39 AM

Spanec

Windows XP Sum Formula in the range with Numeric and NonNumeric data cells

Office 2003

Novice

Join Date: Jan 2012

Posts: 7

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!

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:18 AM.