SUMIF

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
I have a data layout like below
File Amounts per Fee Earner.xls
ABCD
1TotalTransactionTypeHeldFiles
2AdamFreeman(S&PFE-BRD)3Sale0
3AdamFreeman(S&PFE-BRD)7Purchase0
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)
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
are you wanting to count the transaction types for each purchase?
 

Fergus

Well-known Member
Joined
Mar 10, 2004
Messages
1,174
Happens often enough, usually when it looks like your post is not moving to the forum because of a slow / delayed connection so you click "Submit" again - done it myself a couple of times when connection in Bangkok slows to a crawl :devilish: that's how I know.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,052
Messages
5,545,734
Members
410,702
Latest member
clizama18
Top