Become Our Member!

Edit Template

Become Our Member!

Edit Template

USE OF EXCEL FORMULAS SUM, SUMIF & SUMIFS WITH EXAMPLE



In this Excel post we describe Math Category Formulas Sum, Sumif & Sumifs use with Example. So pleas read carefully.






USE OF EXCEL FORMULAS SUM, SUMIF & SUMIFS WITH EXAMPLE

  

SUM

Sum Formula in excel we add two or more numeric cells.

Syntax

SUM(number1, number2 …)

number1 – The first item that you want to add.

number2 – The second item that you want to add. 


Example – In this Sheet Sum of Items Qty =Sum(B2:B4) then press enter you result is 28 display. means 5+8+15 = 28. 

USE OF EXCEL FORMULAS SUM, SUMIF & SUMIFS WITH EXAMPLE


Use of Count, Counta, Countblank, Countif and Countifs with Example

SUMIF

SUMIF function use to conditionally sum the values which match the given single criteria.

Syntax

SUMIF(range, criteria, [sum_range])
range – The range of cells that you want evaluated by criteria.

criteria – The criteria in the form of a number, expression, a cell reference, text, or a function that defines which cells will be added.

sum_range – The actual cells to add, if you want to add cells other than those specified in the range argument. 


Example – In this Sheet we want John total sales so apply this formula =Sumif(A2:A10,”John”,C2:C10) and press enter, here result display 18943, means John total sales is in this sheet 18943. 

USE OF EXCEL FORMULAS SUM, SUMIF & SUMIFS WITH EXAMPLE



Microsoft Excel Easy Notes for Beginners


SUMIFS

SUMIFS is used to conditionally sum the values which match the two or more multiple criteria.

Syntax

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

sum_range – One or more cells to sum, including numbers or names. 

criteria_range1 – The first range in which to evaluate the associated criteria. 



criteria1 – The criteria in the form of a number, expression, cell reference, or text that define which cells in the criteria_range1 argument will be added. 



criteria_range2, criteria2– Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed. 





Example – In this Sheet we want two conditions John total sales in South Region so apply this formula – =Sumifs(C2:C10,B2:B10,”South”, A2:A10,”John”) 

and press enter, here result display 11312, means John total sales in South Region is 11312.
USE OF EXCEL FORMULAS SUM, SUMIF & SUMIFS WITH EXAMPLE

Conclusion 

I hope you understanding Use of Math Category Formulas Sum, Sumif & Sumifs. If any question related this post pleas ask and comment. 

Leave a Reply

Your email address will not be published. Required fields are marked *

About Blog

This Website Blog related to Computer Basic/Advance Knowledge in Hindi Written by Rajesh Sir (20+ Years Teaching Experience of Computer)

Most Recent Posts

  • All Posts
  • Certificate Courses
  • Computer Courses
  • Diploma
  • Education
  • Google Sheet
  • Govt Exams Preparation
  • Typing [ट्यपिंग]
  • Uncategorized
  • UP Sarkari Job
  • अक्सर पूछे जाने वाले प्रश्न [GK]
  • आनलाइन अर्निंग साइट [Online Earning Sits]
  • इंटरनेट ज्ञान [Internet]
  • एक्सेल मैक्रो
  • एम एस वर्ड [MS Word]
  • एस एस एक्से्ल [Excel]
  • कंप्यूटर बुक्स [Computer Books]
  • कम्प्यूटर हार्डवेयर ज्ञान [Computer Hardware]
  • कोरल ड्रा [Corel Draw]
  • गूगल ड्राइव [Google Drive]
  • टेक्नोलॉजी [Technology]
  • टेक्नोलॉजी [Technology]इंटरनेट ज्ञान [Internet]
  • टैली [Tally]
  • डाउनलोड [Download]
  • डिजीटल मार्केटिंग ज्ञान [Digital Marketing]
  • पावर पाइंट [Power Point]
  • फॉटोशॉप [Photoshop]
  • बेसिक ज्ञान [Basic Knowledge]
  • लिब्रा आफिस [Libre Office]
  • सी.सी.सी. महत्वपूर्ण नोटस [CCC Notes]
Play Video

Category

Tags

Excellent Computer is Best Computer Training Center for Learn Job Oriented/ Professional Computer Courses in Online and Offline. 

About Us

How It Works

Accessibility

Support

FAQs

Privacy Policy

Career

Download Our App