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 ^_^
for negative values
=sumif(range, "<0")
for positive values
=sumif(range, ">0")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With