Mega Offer Avail 65% Off in CA IPCC and 50% Off in all CA CS CMA subjects.Coupon- IPCEXAM65 & EXAM50. Call: 088803-20003

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Babita Jain (Personal Assistant)     17 April 2021

Excel SUMIF | SUMIFS | SUM function

Watch Video - Excel Formula Tutorial | All Excel Tutorial Videos

Summary  - 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 (>,<,<>,=) and wildcards (*,?) for partial matching.

Purpose - Sum numbers in a range that meet supplied criteria

Return value - The sum of values supplied.

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. If sum_range is omitted, the cells in range are added together instead.

Watch Video - Excel Formula Tutorial | All Excel Tutorial Videos

 0 Replies

Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Start a New Discussion

Popular Discussion

view more »

Subscribe to the latest topics :
Search Forum:

Trending Tags