Microsoft Office Forums - View Single Post - [Solved] Sum Formula in the range with Numeric and NonNumeric data cells

Thread: [Solved] Sum Formula in the range with Numeric and NonNumeric data cells

View Single Post

Old

01-12-2012, 09:15 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

Here's another way, similar to Peco's, which will ingore any error value:

Code:

=SUM(SUMIF(A2:A1000,{"<0",">0"}))

__________________
Colin

RAD Excel Blog

Reply With Quote