LinkBack URL
About LinkBacks
I have seen function SUMIF.
If I have many rows, how to use SUM if function.
ONLY SUM of cells if
1. values are larger than 0
2. less than 0
I have seen function SUMIF.
If I have many rows, how to use SUM if function.
ONLY SUM of cells if
1. values are larger than 0
2. less than 0
Larger than 0
=SUMIF(A1:A12,">0")
Less than 0
=SUMIF(A1:A12,"<0")
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
Hi, Try
Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
are you looking for two different sumif formulas, one for greater than 0 and one for less than 0? I mean, summing 0 into an equation will not add anything right? the basic sumif for something like greater than 0 is =sumif(range,criteria (in this case ">0" should work) then sum range)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
I have tested like:
=SUMIF(AG24:AG30;AG32:AG35;AG37:AG41;AG43:AG49;AG51;AG53:AG56,">0")
It will refuse. Is it technically possible to set SUM of particular set of cells or this should be only AG24:AG30 and other possibility should be avoided?
1) An what base are you bifurcating the data in column A to different ranges
2) Upload a sample workbook without any confidential data
Punnam
Please check sample.
I have to calculate + values and - values as SUM function.
Easy option is to set each cell as IF function but maybe there is solution as SUMIF
in E3Formula:Please Login or Register to view this content.
in F3Formula:Please Login or Register to view this content.
Try this
Punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks