After all the appreciation and positive feedback, I am
pleased to continue my tips.
Here is the Sixth tip for you. Hope this help you.
Using SUMIF
Formulae is very easy and effective.
|
SUMIF()
& SUMIFS()
|
|
|
|
How it help
us :
|
|
Add all Values in
range with a specific criteria or Multiple Criteria
|
|
|
|
How to use
it :
|
|
=SUMIF(Range,crietria,[sum_range])
|
|
=SUMIFS(sum_range,
criteria_range1, criteria1,[criteria_range2, criteria2],...)
|
Here are some
Examples for the same.
Points to remember while using SUMIF()
- SUMIF() adds values based on a single criteria and SUMIFS()adds values based on a Multiple criteria.
- If sum_range argument is omitted, Excel uses the criteria range (range) as the sum range as default.
- Criteria could be a number, expression, cell reference, text, or a formula
- Criteria which are text or mathematical/logical symbols (such as =,+,-,/,*) should be in double quotes i.e. (“”)
If any of your
friend is also interested for the said excel Tips , then asked them to fill the
form by clicking on the below mentioned link:
If you have something that you want to share with the group, please
write to excelms.tips@gmail.com
Please do share
your valuable feedback. Keep Sharing.
Thanks & Regards,
CA Mohit Bansal
Excel
Enthusiast
+91-9045773456
No comments:
Post a Comment