SUMIF

[MarkAndrews]

I have a data layout like below

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

 

[barry houdini]

Can i replace the name with a cell reference?

Try

=SUMIF(A:A,C1&" *",B:B)

where your name is in C1

 

[MarkAndrews]

Thanks Barry - I'm just in the middle of something else, but i'll give it a try shortly

 

[MarkAndrews]

Barry, my list is column F

I have tried to utilise this formula, to no avail

Please can you assist

Thanks

File Amounts per Fee Earner.xls
	A	B	C	D	E	F	G
1	Total	TransactionType	HeldFiles			Total
2	AdamFreeman(S&PFE-BRD)	3	Sale	0		AdamFreeman(S&PFE-BRD)	10
3	AdamFreeman(S&PFE-BRD)	7	Purchase	0		AilsaKempthorne(S&PFEBRDH/WORKE
4	AilsaKempthorne(S&PFEBRDH/WORKE	4	S&P	0		AlisonSpivey(TECHBRAD)
5	AilsaKempthorne(S&PFEBRDH/WORKE	9	Purchase	0		AllanLee(S&PFE-MAN)
Sheet1

 

[njimack]

I have tried to utilise this formula, to no avail

Looks like its working to me. Your formula in G2 is summing cells B2 and B3. What result were you expecting?

 

[MarkAndrews]

Rather than have to type the name into the formula, can i put the references in F (the list) into the formula?

 

[njimack]

As per Barry's formula earlier:

=SUMIF(A:A,F2&"*",B:B)

 

[MarkAndrews]

Fantastic, thanks ever so much