Need formula for calculating (- values) Details pl find below

[sarath223]

Hi Team,

Here i Have attached excel which i need formula..
to calculate the name against -values and +values..pl help One column i have different names and another coloum i have values life -7,-8,9,5.. i want the ans to come like name and -values total sum & + value Total sum. pl refer the excel

[judgeh59]

try this

put this in Cell F5 and copy down

Please Login or Register  to view this content.

put this in cell G5 and copy down

Please Login or Register  to view this content.

this is not counting Zeros....you can include that by changing one or the other with ">=0"

have fun

[sarath223]

Thanks!!! working fine..

[judgeh59]

glad I could help....