Ignoring Negative Values

solomon_monkey

Posts: n/a

Ignoring Negative Values

Like all things in Excel there must be a way...

Given a column of numbers (say for simplicity 5 numbers) how can you
use a formula to sum them and ignore any that are negative? (e.g. four
of our 5 numbers are 5 and the other is -5 I want my formula to display
20 and not 15 or 25).

Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Getting Count field to recognise rows with negative values in Exc.	hamish	Excel Worksheet Functions	2	June 20th 05 05:06 AM
Bar charts with negative values and label position	Pearl Quan	Charts and Charting in Excel	3	April 25th 05 10:51 PM
switching values from positive to negative	lob	Excel Worksheet Functions	5	February 18th 05 11:11 PM
display negative values as a blank cell in Excel	pherozeb	Excel Discussion (Misc queries)	3	January 5th 05 04:40 AM
display negative values as a blank cell in Excel	Pheroze Bharucha	Excel Discussion (Misc queries)	0	January 4th 05 10:51 PM

All times are GMT +1. The time now is 07:18 AM.

Menu

About Us