sum of rows based on tow other columns, place result on first occurance

[FROGGER24]

afternoon everyone,
In my spreadsheet I need to look at the values in D2 and E2 to see if they equal any rows below in dataset (data sorted in columns), if so I would like the sum of the values in column I, the result will be in column K. would like the result to be in the first row of that "unique" dataset

Thanks

 

[jasonb75]

Best guess from your description would be something like

=IF(COUNTIFS(D$2:D2,D2,E$2:E2,E2)=1,SUMIFS(I$2:I2,D$2:D2,D2,E$2:E2,E2),"")

A mini sheet created with XL2BB is always a good way to add meaning to a description.

 

[FROGGER24]

Thanks for response. When I entered the formula I get zero as the results. for clarification purposes I need to look in columns D and E for all matches of that data (PO # and material name) Column I have the shipped quantity, so i want to add all the matches column I based on matches in column D&E and put sum in the first row of the match in column K. This is my attempt, I don't know how to make it work if there or additional matches in column D&E.
=IF(CONCATENATE(D2&E2=D3&E3),I3,I2)

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also please post some sample data showing expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[FROGGER24]

Trip Number	Grade				A											BL NSV
USEVESSAPC-2101-013	apple				30											10
USEVESSAPC-2101-013	apple															20
5214315	grape				60											10
5214315	grape															20
5214315	grape															30
2020-BT-BM-EHC65-20	nanner				400											400

Would to look in columns D and E if the rows are duplicates then sum same rows as column d and e in "T" with results in column "I". Thanks

 

[Fluff]

How about

=IF(COUNTIFS(D$2:D2,D2,E$2:E2,E2)=1,SUMIFS(T:T,D:D,D2,E:E,E2),"")

Please don't forget this

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[jtakw]

Hi,

Try this:

Book3.xlsx
	D	E				I											T
1	Trip Number	Grade				A											BL NSV
2	USEVESSAPC-2101-013	apple				30											10
3	USEVESSAPC-2101-013	apple															20
4	5214315	grape				60											10
5	5214315	grape															20
6	5214315	grape															30
7	2020-BT-BM-EHC65-20	nanner				400											400
Sheet857

Cell Formulas
Range	Formula
I2:I7	I2	=IF(COUNTIFS(D$2:D2,D2,E$2:E2,E2)=1,SUMIFS(T$2:T$100,D$2:D$100,D2,E$2:E$100,E2),"")

 

[FROGGER24]

How about

=IF(COUNTIFS(D$2:D2,D2,E$2:E2,E2)=1,SUMIFS(T:T,D:D,D2,E:E,E2),"")

Please don't forget this

Nailed it thank you for your help, profile updated

 

[Fluff]

Glad we could help & thanks for the feedback.