Help with SUMIF

[Halmsteen]

HELP.jpgHi,

I seem to be in trpuble with the sumif formula or did I use the wrong formula?
I am trying to get the total $$$ for each person from all three tables. Thanks.
Excel sheet is attached.

[Saarang84]

Hi,

I can find the image only, can you upload the workbook - its missing.

[FDibbins]

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

[Halmsteen]

Will do Sir, still trying to upload a file though.
Sorry for all the inconveniences caused.

[hemesh]

assuming your tables are equal in size
copy paste below in E21
=SUMPRODUCT(--($D$3:$D$18=D21)*($E$3:$E$18)+($H$3:$H$18=D21)*($I$3:$I$18)+($L$3:$L$18=D21)*($M$3:$M$18))

[Tony Valko]

Try this...

Data Range

	D	E	F	G	H	I	J	K	L	M
1	-----	-----	-----	-----	-----	-----	-----	-----	-----	-----
2	Name1	90			Name1	38			Name1	75
3	Name2	22			Name2	41			Name2	88
4	Name3	38			Name3	58			Name3	99
5	Name4	56			Name4	83			Name4	17
6
7
8	Name1	203
9	Name2	151
10	Name3	195
11	Name4	156

This formula entered in E8 and copied down:

=SUMIF(D$2:L$5,D8,E$2:M$5)

[Keashan]

Hi,

Enter below equation to the cell E21 & copy down.

=SUMIF($D$3:$D$18,B21,$E$3:$E$18)+SUMIF($H$3:$H$18,B21,$I$3:$I$18)+SUMIF($L$3:$L$18,B21,$M$3:$M$18)
You can learn more about sumif by visiting below

Advance Uses of IF