SumIF help

[JonWSealmaster]

I need to add the numbers in column I for identical cells in column A.

Helper	FullName	ItemCode	ItemDesc	2024​	NetTotal	StoreId	2023​	Difference	Total
, S1000B13	,	S1000B	SS COAL TAR SLR BULK	655​	$3,058.85​	13​	0​	655​
, S1000B5	,	S1000B	SS COAL TAR SLR BULK	50​	$202.50​	5​	0​	50​
, S1000UB13	,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	926​	$3,592.23​	13​	0​	926​
, S1097UB13	,	S1097UB	PMM- POLYMER MODIFIED MASTERSEAL ULTRA BLEND WITH SAND	896​	$3,727.36​	13​	0​	896​
, S1000B8	,	S1000B	SS COAL TAR SLR BULK	2826​	$11,153.10​	8​	0​	-2826​
, S1000B9	,	S1000B	SS COAL TAR SLR BULK	113​	$465.56​	9​	0​	-113​
, S1000UB8	,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	972​	$3,301.50​	8​	0​	-972​
, S1001B4	,	S1001B	COAL TAR SEALER/WATER ADDED	655​	$1,870.42​	4​	0​	-655​
, S1010B4	,	S1010B	MS ASPH EMUL SLR BULK	300​	$984.00​	4​	0​	-300​
, S1097B4	,	S1097B	PMM- POLYMER MODIFIED MASTERSEAL - BULK	0​	$0.00​	4​	0​	0​
, ABC SEALCOATINGS1000B9	, ABC SEALCOATING	S1000B	SS COAL TAR SLR BULK	951​	$4,403.61​	9​	0​	951​
, Adams PavingS1000UB5	, Adams Paving	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	685​	$2,138.75​	5​	0​	-685​
, Advanced Roofing and PavingS1000B5	, Advanced Roofing and Paving	S1000B	SS COAL TAR SLR BULK	265​	$1,066.65​	5​	0​	265​
, Advanced Roofing and PavingS1000B6	, Advanced Roofing and Paving	S1000B	SS COAL TAR SLR BULK	230​	$922.30​	6​	0​	230​
, ALL ABOUT ASPHALTS1000B9	, ALL ABOUT ASPHALT	S1000B	SS COAL TAR SLR BULK	304​	$1,419.68​	9​	0​	304​
, ARCHIE'S VETERAN WATERPROOFINGS1000UB5	, ARCHIE'S VETERAN WATERPROOFING	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	100​	$343.00​	5​	0​	100​
, ASHPALT MAINTANCES1000B8	, ASHPALT MAINTANCE	S1000B	SS COAL TAR SLR BULK	250​	$962.50​	8​	0​	-250​
, ASPHALT RESTORATION SERVICES1170B10	, ASPHALT RESTORATION SERVICE	S1170B	Gem FedSpec Sealer-Bulk	2720​	$11,258.46​	10​	500​	2220​
, B&E SEALCOATINGS1000B8	, B&E SEALCOATING	S1000B	SS COAL TAR SLR BULK	2430​	$10,570.50​	8​	2300​	130​

EDIT:
In column J, I need to SUM column I where Column A are identical cells.

 

[Fluff]

Hi & welcome to MrExcel.
There are no identical cells in col A, do you mean col C?

 

[JonWSealmaster]

My boss is changing this on the fly, I need to now sum all identical entries for column B, but still have a total even if there's only a single entry, let me post some more data, for example, the total in the first row should be 770, the second and third row would add together -1450 and -976, rows 4 5 and 6 would added together 572, 1214, -30

Does that make sense?

2023 CASH GEMSEAL, S1250B10	2023 CASH GEMSEAL,	S1250B	Gem Polytar Sealer-Bulk	770​	$3,670.20​	10​	0​	770​
2023 CASH SAVANNAH, S1000B9	2023 CASH SAVANNAH,	S1000B	SS COAL TAR SLR BULK	1450​	$6,175.50​	9​	0​	-1450​
2023 CASH SAVANNAH, S1000UB9	2023 CASH SAVANNAH,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	976​	$3,413.74​	9​	0​	-976​
2024 CASH DORAVILLE, S1000B5	2024 CASH DORAVILLE,	S1000B	SS COAL TAR SLR BULK	660​	$2,630.90​	5​	88​	572​
2024 CASH DORAVILLE, S1000UB5	2024 CASH DORAVILLE,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	1575​	$5,340.85​	5​	361​	1214​
2024 CASH DORAVILLE, S1100B5	2024 CASH DORAVILLE,	S1100B	Gem Black Diamond Sealer-Bulk	30​	$146.40​	5​	0​	-30​
3PI MCDONALDS, S1000B8	3PI MCDONALDS,	S1000B	SS COAL TAR SLR BULK	250​	$1,087.50​	8​	0​	250​
A & C SOUTHERN ENTERPRISES LLC, S1130B10	A & C SOUTHERN ENTERPRISES LLC,	S1130B	Gem Black Diamond XL Sealer -Bu	525​	$2,572.50​	10​	2330​	-1805​
A & C SOUTHERN ENTERPRISES LLC, S1250B10	A & C SOUTHERN ENTERPRISES LLC,	S1250B	Gem Polytar Sealer-Bulk	1885​	$8,888.35​	10​	0​	1885​
A Buck Asphalt Paving, S1100B10	A Buck Asphalt Paving,	S1100B	Gem Black Diamond Sealer-Bulk	1100​	$4,925.00​	10​	0​	-1100​
A TO Z, S1000UB4	A TO Z,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	3713​	$12,425.38​	4​	2595​	1118​
A TO Z, S1000UB5	A TO Z,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	400​	$1,344.00​	5​	0​	400​
A TO Z, S1000UB6	A TO Z,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	1345​	$4,182.95​	6​	0​	-1345​
A&A ASPHALT, S1000UB4	A&A ASPHALT,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	400​	$1,271.24​	4​	1738​	-1338​
A&J'S SEALCOATING, S1000UB5	A&J'S SEALCOATING,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	550​	$1,860.40​	5​	75​	475​
A&J'S SEALCOATING, S1000B5	A&J'S SEALCOATING,	S1000B	SS COAL TAR SLR BULK	350​	$1,390.50​	5​	2442​	-2092​
A-1 PAVING, S1000B5	A-1 PAVING,	S1000B	SS COAL TAR SLR BULK	770​	$2,867.10​	5​	0​	-770​
A-1 PAVING, S1000UB5	A-1 PAVING,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	310​	$957.90​	5​	0​	-310​
A1 SEALCOATING AND PAVING, S1000B5	A1 SEALCOATING AND PAVING,	S1000B	SS COAL TAR SLR BULK	252​	$936.92​	5​	0​	-252​
AAA PAVING, S1170B10	AAA PAVING,	S1170B	Gem FedSpec Sealer-Bulk	135​	$567.00​	10​	0​	135​
ABLE ASPHALT, S1170B10	ABLE ASPHALT,	S1170B	Gem FedSpec Sealer-Bulk	425​	$1,768.00​	10​	200​	225​
ACE PAVING & MAINTENANCE LLC, S1000UB5	ACE PAVING & MAINTENANCE LLC,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	475​	$1,416.34​	5​	0​	-475​
ACE PAVING & MAINTENANCE LLC, S1000UB6	ACE PAVING & MAINTENANCE LLC,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	550​	$1,677.50​	6​	0​	-550​
ACE TREE SERVICE LLC, S1000UB4	ACE TREE SERVICE LLC,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	400​	$1,236.00​	4​	0​	-400​
ACE TREE SERVICE LLC, S1000UB5	ACE TREE SERVICE LLC,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	990​	$3,019.50​	5​	0​	-990​
ACL MAINTENANCE AND SERVICE INC., S1000B5	ACL MAINTENANCE AND SERVICE INC.,	S1000B	SS COAL TAR SLR BULK	490​	$1,771.90​	5​	0​	-490​
ACL MAINTENANCE AND SERVICE INC., S1000UB5	ACL MAINTENANCE AND SERVICE INC.,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	315​	$960.75​	5​	0​	-315​

 

[Fluff]

Ok, how about

=SUMIFS(I:I,B:B,B2)

 

[JonWSealmaster]

Alright, that's almost got it, but is there a way so that the total only shows on the last row of added items, for example all of the full names, is there a way to get -2339 to only show on the last row added together and the rest are blank?

Helper	FullName	ItemCode	ItemDesc	2024​	NetTotal	StoreId	2023​	Difference	Total
, S1000B13	,	S1000B	SS COAL TAR SLR BULK	655​	$3,058.85​	13​	0​	655​	-2339​
, S1000B5	,	S1000B	SS COAL TAR SLR BULK	50​	$202.50​	5​	0​	50​	-2339​
, S1000UB13	,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	926​	$3,592.23​	13​	0​	926​	-2339​
, S1097UB13	,	S1097UB	PMM- POLYMER MODIFIED MASTERSEAL ULTRA BLEND WITH SAND	896​	$3,727.36​	13​	0​	896​	-2339​
, S1000B8	,	S1000B	SS COAL TAR SLR BULK	2826​	$11,153.10​	8​	0​	-2826​	-2339​
, S1000B9	,	S1000B	SS COAL TAR SLR BULK	113​	$465.56​	9​	0​	-113​	-2339​
, S1000UB8	,	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	972​	$3,301.50​	8​	0​	-972​	-2339​
, S1001B4	,	S1001B	COAL TAR SEALER/WATER ADDED	655​	$1,870.42​	4​	0​	-655​	-2339​
, S1010B4	,	S1010B	MS ASPH EMUL SLR BULK	300​	$984.00​	4​	0​	-300​	-2339​
, S1097B4	,	S1097B	PMM- POLYMER MODIFIED MASTERSEAL - BULK	0​	$0.00​	4​	0​	0​	-2339​
, ABC SEALCOATINGS1000B9	, ABC SEALCOATING	S1000B	SS COAL TAR SLR BULK	951​	$4,403.61​	9​	0​	951​	951​
, Adams PavingS1000UB5	, Adams Paving	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	685​	$2,138.75​	5​	0​	-685​	-685​
, Advanced Roofing and PavingS1000B5	, Advanced Roofing and Paving	S1000B	SS COAL TAR SLR BULK	265​	$1,066.65​	5​	0​	265​	495​
, Advanced Roofing and PavingS1000B6	, Advanced Roofing and Paving	S1000B	SS COAL TAR SLR BULK	230​	$922.30​	6​	0​	230​	495​
, ALL ABOUT ASPHALTS1000B9	, ALL ABOUT ASPHALT	S1000B	SS COAL TAR SLR BULK	304​	$1,419.68​	9​	0​	304​	304​
, ARCHIE'S VETERAN WATERPROOFINGS1000UB5	, ARCHIE'S VETERAN WATERPROOFING	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	100​	$343.00​	5​	0​	100​	100​
, ASHPALT MAINTANCES1000B8	, ASHPALT MAINTANCE	S1000B	SS COAL TAR SLR BULK	250​	$962.50​	8​	0​	-250​	-250​
, ASPHALT RESTORATION SERVICES1170B10	, ASPHALT RESTORATION SERVICE	S1170B	Gem FedSpec Sealer-Bulk	2720​	$11,258.46​	10​	500​	2220​	2220​
, B&E SEALCOATINGS1000B8	, B&E SEALCOATING	S1000B	SS COAL TAR SLR BULK	2430​	$10,570.50​	8​	2300​	130​	130​
, BART BARTONS1000B8	, BART BARTON	S1000B	SS COAL TAR SLR BULK	280​	$1,218.00​	8​	0​	280​	680​
, BART BARTONS1000UB8	, BART BARTON	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	400​	$1,460.88​	8​	0​	400​	680​
, Billy SherlockS1000B5	, Billy Sherlock	S1000B	SS COAL TAR SLR BULK	150​	$601.50​	5​	0​	150​	150​
, Brandon RobinsonS1000B8	, Brandon Robinson	S1000B	SS COAL TAR SLR BULK	25​	$108.75​	8​	60​	-35​	-35​
, BROWN LANDSCAPE PAVING AND CRUSHINGS1097UB13	, BROWN LANDSCAPE PAVING AND CRUSHING	S1097UB	PMM- POLYMER MODIFIED MASTERSEAL ULTRA BLEND WITH SAND	100​	$416.00​	13​	0​	100​	100​
, CLEAR GRADE CONTRACTINGS1096UB4	, CLEAR GRADE CONTRACTING	S1096UB	PMCTS ULTRA BLEND	600​	$2,412.00​	4​	0​	600​	600​
, CLEVER CHOICES1000B9	, CLEVER CHOICE	S1000B	SS COAL TAR SLR BULK	100​	$467.00​	9​	0​	100​	150​
, CLEVER CHOICES1000UB9	, CLEVER CHOICE	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	50​	$193.96​	9​	0​	50​	150​
, COMMERCIAL ASPHALT COATINGSS1000B9	, COMMERCIAL ASPHALT COATINGS	S1000B	SS COAL TAR SLR BULK	143​	$667.81​	9​	1621​	-1478​	-1478​
, CROSSROADS CONSTRUCTION INCS1000B9	, CROSSROADS CONSTRUCTION INC	S1000B	SS COAL TAR SLR BULK	388​	$1,656.76​	9​	0​	-388​	-688​
, CROSSROADS CONSTRUCTION INCS1000UB9	, CROSSROADS CONSTRUCTION INC	S1000UB	SS COAL TAR ULTRA BLEND WITH SAND	300​	$1,023.00​	9​	0​	-300​	-688​

 

[Fluff]

How about

=IF(COUNTIFS(B$2:B2,B2)=COUNTIFS(B:B,B2),SUMIFS(I:I,B:B,B2),"")

 

[JonWSealmaster]

How about

=IF(COUNTIFS(B$2:B2,B2)=COUNTIFS(B:B,B2),SUMIFS(I:I,B:B,B2),"")

Fluff, you are the BEST!! Thank you so much for your help!!

 

[Fluff]

You're welcome & thanks for the feedback.