Thursday, August 3, 2023

Excel - How to sum of all positve numbers or negative numbers from a range of values

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

Featured Post

OIC - Extract Microsoft 365 Outlook Email Attachments and upload them to OCI Object storage

Use Case: A client has a requirement to automate the processing of email attachments received in their Microsoft 365 Outlook inbox. Currentl...