Sum a range of absolute values
 

I am looking to sum a range of cells but not include in the sum any
negative values.

Thus far all that i could think of doing was a round about way via the
ABS and the SUM functions but was looking to see if there was a
function that would do the whole job lot in one go!!


--
lister_d_000169
------------------------------------------------------------------------
lister_d_000169's Profile: http://www.excelforum.com/member.php...o&userid=32950
View this thread: http://www.excelforum.com/showthread...hreadid=547428

Sum a range of absolute values
 

=sumproduct(--(a1:a1000),a1:a100)

"lister_d_000169" wrote:


I am looking to sum a range of cells but not include in the sum any
negative values.

Thus far all that i could think of doing was a round about way via the
ABS and the SUM functions but was looking to see if there was a
function that would do the whole job lot in one go!!


--
lister_d_000169
------------------------------------------------------------------------
lister_d_000169's Profile: http://www.excelforum.com/member.php...o&userid=32950
View this thread: http://www.excelforum.com/showthread...hreadid=547428

Sum a range of absolute values
 

lister_d_000169

=SUMIF(A1:A100,"0")

That will sum only the positive numbers in Cells A1:A100

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=547428

Sum a range of absolute values
 

Cheers Ron

i had toyed with the sumif but never put the " " round teh criteria

cheers !!




Ron Coderre Wrote:
lister_d_000169

=SUMIF(A1:A100,"0")

That will sum only the positive numbers in Cells A1:A100

Does that help?

Regards,
Ron


--
lister_d_000169
------------------------------------------------------------------------
lister_d_000169's Profile: http://www.excelforum.com/member.php...o&userid=32950
View this thread: http://www.excelforum.com/showthread...hreadid=547428

Sum a range of absolute values
 

Whilst this will work, it does seem a little hard on the SUMIF function
which will do it with fewer keystrokes!!!
Duke Carey wrote:
=sumproduct(--(a1:a1000),a1:a100)

"lister_d_000169" wrote:


I am looking to sum a range of cells but not include in the sum any
negative values.

Thus far all that i could think of doing was a round about way via the
ABS and the SUM functions but was looking to see if there was a
function that would do the whole job lot in one go!!


--
lister_d_000169
------------------------------------------------------------------------
lister_d_000169's Profile: http://www.excelforum.com/member.php...o&userid=32950
View this thread: http://www.excelforum.com/showthread...hreadid=547428