| Connect us with          
|now www.excelbasics.in is moved to www.basictutorials.in | Learn excel,word,powerpoint,html tutorials..etc in Kannada | ಕನ್ನಡದಲ್ಲಿ ಕಲಿಯಿರಿ excel,word,power point,html ಮತ್ತು ಎಲ್ಲಾ tech updates ಗಾಗಿ ನಮ್ಮ ಚಾನೆಲ್ ನ್ನು subscribe ಮಾಡಿ.


Note:-Before starting any Formula or Function you need to add (=)

SUMIF is the function which is used to calculate a sum of values in a range, that satisfies a specific condition you specify instead of calculating the sum of an entire range.in other words it is the combinations of SUM & IF function.it adds all numbers in a range of cells based on one criteria. Learn how to use the SUMIF function here. below we provided downlodable sample sheet & video for your understanding

Syntax:- =SUMIF(range, criteria, [sum_range])

After watching video you can download below sample sheet. & it helps you to do practice more.please subscribe for more videos in our youtube channel.if you like our tutorial please share it on facebook & youtube below.
please leave your comments & suggestion in below form for better posts.