Usecase: we have a range of numbers in excel file, we have to sum all positive numbers and negative numbers separately from that range.
Steps: Use SUMIF() function to achieve this requirment:
To sum positive numbers
=SUMIF(G2:G366,"<0")
Output: -2590
To sum positive numbers
=SUMIF(G2:G366,">0")
Output: 2590
No comments:
Post a Comment