Hello,
After all the appreciation
and positive feedback, I am pleased to continue my tips.
Here is the Seventeenth tip for you. Hope this help
you.
Using IF Command with SUMIF
Formulae is very easy and effective. Hope it will help you in
ease your work.
Points to remember while using IF formulae with SUMIF ()
1. IF Command is used for
the outcome in True or False.
2. Gives command for “True”
value and “False” Value without Double quote i.e. (“)
3. SUMIF() adds values based
on a single criteria and SUMIFS()adds values based on a Multiple criteria.
4. If sum_range argument is omitted, Excel
uses the criteria range (range) as the sum range as default.
5. Criteria could be a
number, expression, cell reference, text, or a formula
6. Criteria which are text
or mathematical/logical symbols (such as =, +,-, /,*) should be in double
quotes i.e. (“”)
If any of your friends is
also interested for the said excel Tips, then asked them to fill the form by
clicking on the below mentioned link:
Please do share your
valuable feedback. Keep Sharing.
Thanks & Regards,
CA Mohit Bansal
Excel Enthusiast
+91-9045773456
No comments:
Post a Comment