Bl4ckPantha
New member
- Joined
- May 23, 2018
- Messages
- 12
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hi Guru's,
I have a set of data with multiple ranges which contain matches. Below is an example data set:
Basically I would like to return the sum value of column header 4 for all matching/duplicated letters under Header 1 and Header 3. In this example there are the letters "a" & "c" under both header 1 and header 2. Therefore, the sum value returned should be 8 (3+5).
Thank you for your time Guru's.
I have a set of data with multiple ranges which contain matches. Below is an example data set:
Header 1 | Header 2 | Header 3 | Header 4 |
a | 1 | a | 3 |
c | 3 | e | 2 |
b | 1 | c | 5 |
z | 4 | h | 1 |
Basically I would like to return the sum value of column header 4 for all matching/duplicated letters under Header 1 and Header 3. In this example there are the letters "a" & "c" under both header 1 and header 2. Therefore, the sum value returned should be 8 (3+5).
Thank you for your time Guru's.