In a nutshell let's talk about the sum if/ sum ifs function. I am going to tell you in details.
Why we use the Sum-ifs function: If we sum in any value for a given criteria We use sum if for single condition and we use sum ifs for multiple condition.
Its very strong and powerful functions. If the data is very big by this we can analyze the data in an easy way.
Very few people know about that we can use sum-ifs function for single condition also.
But this logic is very useful to work with. Let us take an example.
i will give many example for understanding.
we will describe example in below mention categories.
a. easy b. normal c. difficult and d logical way
Easy.
Why we use the Sum-ifs function: If we sum in any value for a given criteria We use sum if for single condition and we use sum ifs for multiple condition.
Its very strong and powerful functions. If the data is very big by this we can analyze the data in an easy way.
Very few people know about that we can use sum-ifs function for single condition also.
But this logic is very useful to work with. Let us take an example.
i will give many example for understanding.
we will describe example in below mention categories.
a. easy b. normal c. difficult and d logical way
Easy.
to be continued.
No comments:
Post a Comment