getting the sum of cells based on other cells in a different column

[mabsrgs]

I have the original and duplicates of a concatenated 2 columns but need to add up the values of their cells. How can I do that?

Rows 2 & 3 have same values in column B and Column D. However column F has different values which I need to add together. Thus, I want to add 10.00 + 14.01 as well as 71.71+0.12 and put it in column G beside the word original
B D E F G
2 CLAIM CODE PAID FIND DUP ADDED VALUE
3 57849 90633 10.00 duplicate
4 57849 90633 14.01 original 24.01
5 57849 99213 71.71 duplicate
6 57849 99213 0.12 original 71.83

-------
I'm trying to add column E's values and put them in column G so that when I filter out column F's originals the added value will appear.

[jtakw]

Hi,

Is this what you mean:

Excel 2016 (Windows) 64 bit

	B	C	D	E	F	G	H
1	CLAIM		CODE		PAID	FIND DUP	ADDED VALUE
2	57849		90633		10	duplicate
3	57849		90633		14.01	original	24.01
4	57849		99213		71.71	duplicate
5	57849		99213		0.12	original	71.83

Sheet: Sheet28

Excel 2016 (Windows) 64 bit

	H
2	=IF(G2="original",SUMIFS(F$2:F$5,B$2:B$5,B2,D$2:D$5,D2),"")

Sheet: Sheet28

H2 formula copied down.

[mabsrgs]

Thanks for the post. I'm still learning and trying to understand excel. I tried to enter the suggested answer with the data that I have and it seems everything is turning out to be "0".

[jtakw]

Does you PAID column look like my sample above, meaning Only numbers, not a mix of Text and Numbers?

If it's only numbers, how did they get there? By formula, import, manual entry?

I suspect the numbers may actually be Text and not real numbers.

[mabsrgs]

They are numbers. They were entered manually as part of a larger file. I rechecked my entries. My goodness I entered a value wrong in the formula: =IF(R2="original",SUMIFS(P$2:P$23029,H$2:H$23029,H2,L$2:L$23029,L2),"")

I had the L2 as P2. I will check this again and see.. I think you got it!! Thanks so much!!

[jtakw]

I think you got it!! Thanks so much!!

If you found my posts helpful, add rep would be appreciated, click the "Star" at the lower left corner of the posts you found helpful.

If your issue has been "Solved", please mark the thread as such, thank you.