« Avoid Formula Rebuilding (small tip) | Difference Between - "Forecast" & "Trend" » |
Group SUM of them
Formulas, Tutorial, Arrays, ActiveX & Form Controls, 3D-formulasHi there,
This post is a consolidation of SUM of the posts that I have wrote earlier. The reason for why I am grouping them is to let you know how many ways the simple SUM function can be used in our day to day reporting.
Let me proceed to first example:
...
When we have a list of values and need to find the sum of only top two values, then here is a solution
This explains how to SUM the values based on the cell colour. This is an awesome trick where we use helper column to get this done.
SUM VALUES BASED ON TWO CONDITIONS
In this post, we can learn how to work with SUM function where there is two limitations or conditions needs to match to achieve the results. This example is given to my students in one of the questionnaires in the program "MASTER@HOME"
DIFFERENCE BETWEEN SUM and AUTOSUM
This post is a controversy post. There is a slight difference between these two features however, it looks the same in terms of functionality. Go dig into it and try to find the difference. If you have other views please do share it in the below comments section.
In this post, we can learn how to sum the range of values based on check box, which means when you check mark the value will be considered to be summed. This is a different approach to SUM the values. This example is mostly helpful when we have more than one product to sell and when the customer purchases the products it is so easy to bill him with the total amount payable. Try this, you will definitely love it.
Here you can also learn ActiveX Controls and Form Controls, check this PART1 and PART2 here
In this topic, we will explain the importance of SUM function and how to use it DYNAMICALLY. Watch out this space...!
SUMPRODUCT can be used to COUNT
SUMPRODUCT function can be used for multi-purpose results however, here we have used to count the range of cells based on the condition. In this post, this function will replace the usage of COUNTIF function. Check this now and see what awesomeness it does for our day-to-day work.
Apart from these SUM examples, I have used a story telling technique to few of the functions that are covered in this exceltox.com can be seen in "Learn Formulas"
Above all, there will be some challenges while working on these functions, right? so, here is How To Crack Formula Errors?.
If you want to Master Excel Formulas, here is our FORMULAS CRASH COURSE.
DID YOU LIKE THIS?
Please share your thoughts on this post using below comments section.
If you like this post, please do share it on your social networking sites by clicking on the icons placed around the blog.
If you want to receive monthly newsletters and exceltoxl updates to your inbox regularly, REGISTER here for free.
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments