MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
I have a data layout like below
What i would like to do is work out the cumulative figure for each person (they can appear more than once) from column B
Can i use SUMIF, or SUMPRODUCT (i have never used sumproduct)
TIA
File Amounts per Fee Earner.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Total | TransactionType | HeldFiles | |||
2 | AdamFreeman(S&PFE-BRD) | 3 | Sale | 0 | ||
3 | AdamFreeman(S&PFE-BRD) | 7 | Purchase | 0 | ||
Sheet1 |
What i would like to do is work out the cumulative figure for each person (they can appear more than once) from column B
Can i use SUMIF, or SUMPRODUCT (i have never used sumproduct)
TIA