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

01-12-2012, 09:15 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Sum Formula in the range with Numeric and NonNumeric data cells

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:31 AM.