CALCULATING NEGATIVE AND POSITIVE NUMBER WITH SUMIF FUNCTION
Hi Excel Users,
Positive and Negative Numbers
Have you ever had a column with positive and negative numbers, but would like to sum the positive and negative numbers separately?
This can be done by using the SUMIF function.
Example:
SUMIF SUMIF(range,criteria,sum_range)
Range: Is the range of cells that you want evaluated by criteria. Cells in each range must be numbers or names, arrays, or references that contain numbers. Blank and text values are ignored.
Criteria: Is the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, “32”, or “apples”.
Sum_range : Are the actual cells to add if their corresponding cells in range match criteria. If sum_range is omitted, the cells in range are both evaluated by criteria and added if they match criteria.
Applies To: MS Excel 2003, 2007, 2010, 2013 and 2016
1. To add the positive numbers as per the example:
a. Select the desired cell (E13)
b. Enter in the below formula
c. Press Enter.
2. To add the negative numbers:
a. Select the desired cell (E14)
b. Enter in the below formula:
c. Press Enter.
Hope you've learnt something new in Excel?
Please drop your comment
Join our Advanced Excel Data Analytics Masterclass
Visit www.leadleapconsult.com to register
Call +2348062468296 to register
Watch video CALCULATING NEGATIVE AND POSITIVE NUMBER WITH SUMIF FUNCTION online without registration, duration hours minute second in high quality. This video was added by user Akerele Oluwasogo (Mr Excel) 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,709 once and liked it 15 people.