Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I sum negative and positive value separately in Google Sheets

In the google sheets, I have a bunch of negative and positive amounts in the same vertical rows. Now in a particular cell, I want to show all the sum of positive values and in another cell, I want to show the sum of all negative values. I want to calculate the total debit and credit amount actually.

Here are some sample data I wanna calculate Sample data

Any help will ve appreciated ^_^

like image 405
Mehrab Mohul Avatar asked Oct 28 '25 08:10

Mehrab Mohul


1 Answers

for negative values

=sumif(range, "<0")

for positive values

=sumif(range, ">0")
like image 155
eNc Avatar answered Oct 31 '25 13:10

eNc