In the last post we have described easy sum-ifs for you, I hope you have understood.
Now we have given the next example of sum ifs. There is another condition which means. It consists of two conditions.
As you know the sheet has three columns 1. Zone 2. Value 3. Bucket.
Now we need bucket wise and zone wise amount.
This means how zone wise and bucket wise values are.
sheet has three columns 1. Zone 2. Value 3. Bucket.
In this, the value is divided into two parts. One is a zone and the other is a bucket. If we look carefully, the value that is arrived at is divided by Zone and bucket.
If you have any formulation problem, you can comment and I will solve it.
Now we have given the next example of sum ifs. There is another condition which means. It consists of two conditions.
As you know the sheet has three columns 1. Zone 2. Value 3. Bucket.
Now we need bucket wise and zone wise amount.
This means how zone wise and bucket wise values are.
sheet has three columns 1. Zone 2. Value 3. Bucket.
In this, the value is divided into two parts. One is a zone and the other is a bucket. If we look carefully, the value that is arrived at is divided by Zone and bucket.
If you have any formulation problem, you can comment and I will solve it.
No comments:
Post a Comment