excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi!
i need a clever way to check if some the text/values in column a is equal then sum the amount/numbers in the next colmun,
like a1:a8 is equal so i want to sum b1:b8 in c1,
and a9 have no equal sum b9 in c9,
and a10:a12 are equal so sum b10:b12 in c10
and so on....
can anyone please help?
i need a clever way to check if some the text/values in column a is equal then sum the amount/numbers in the next colmun,
like a1:a8 is equal so i want to sum b1:b8 in c1,
and a9 have no equal sum b9 in c9,
and a10:a12 are equal so sum b10:b12 in c10
and so on....
can anyone please help?
test | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | 1-1-2-5 | 0 | 24 | ||
2 | 1-1-2-5 | 1 | |||
3 | 1-1-2-5 | 2 | |||
4 | 1-1-2-5 | 3 | |||
5 | 1-1-2-5 | 0 | |||
6 | 1-1-2-5 | 5 | |||
7 | 1-1-2-5 | 11 | |||
8 | 1-1-2-5 | 2 | |||
9 | 2-3-4-5 | 3 | 3 | ||
10 | 11-12-1-2 | 12 | 24 | ||
11 | 11-12-1-2 | 3 | |||
12 | 11-12-1-2 | 9 | |||
13 | 8-9-9-1 | 10 | 35 | ||
14 | 8-9-9-1 | 15 | |||
15 | 8-9-9-1 | 0 | |||
16 | 8-9-9-1 | 8 | |||
17 | 8-9-9-1 | 2 | |||
test |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1 | C1 | =SUM(B1:B8) |
C9 | C9 | =SUM(B9) |
C10 | C10 | =SUM(B10:B12) |
C13 | C13 | =SUM(B13:B17) |