hardeep.kanwar
Well-known Member
- Joined
- Aug 13, 2008
- Messages
- 691
Hello Experts
How can change my Sumif Function that is Show like this. In first example the Function repeat many times See Column C.
I want this look
How can change my Sumif Function that is Show like this. In first example the Function repeat many times See Column C.
Excel Workbook | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Original | ||||
2 | Total 1 | 2 | 28 | ||
3 | Total 1 | 2 | 28 | ||
4 | Total 1 | 2 | 28 | ||
5 | Total 1 | 5 | 28 | ||
6 | Total 1 | 8 | 28 | ||
7 | Total 1 | 9 | 28 | ||
Sheet |
I want this look
Excel Workbook | |||||
---|---|---|---|---|---|
F | G | H | |||
1 | I want this | ||||
2 | Total 1 | 2 | 28 | ||
3 | Total 1 | 2 | * | ||
4 | Total 1 | 2 | * | ||
5 | Total 1 | 5 | * | ||
6 | Total 1 | 8 | * | ||
7 | Total 1 | 9 | * | ||
8 | Total 10 | 5656 | 17854 | ||
9 | Total 10 | 565 | * | ||
10 | Total 10 | 65 | * | ||
11 | Total 10 | 566 | * | ||
12 | Total 10 | 5546 | * | ||
13 | Total 10 | 5456 | * | ||
Sheet |