The Excel SUMIF function returns the sum of cells that meet a single condition.
Criteria can be applied to dates, numbers, and text.
The SUMIF function supports logical operators (>,<,<>,=).
Syntax
SUMIF (range, criteria, [sum_range])
Arguments
range - The range of cells that you want to apply the criteria against.
criteria - The criteria used to determine which cells to add.
sum_range - [optional] The cells to add together.
The example shows the use of SUMIF in summing up the sales quantities for year >2012.
The SUMIF function is used again to calculate the total sales quantity as per each category.
In another example SUMIF function is used on date. We enter the enquiry date and the function calculates the total sale quantities on and after the enquiry date.
Now you know how to use SUMIF function. If you have any questions feel free to contact me at dataentryikc@gmail.com
I will be happy to help you. 👍👍
0 comments:
Post a Comment
If you have any queries, please let me know.