If cells in column "B" contain the same text (name), then add together corresponding values in the rows located in column "L"

[cweaver]

I'm working on trying to add together invoice balances to create a TOTAL balance for each customer who hasn't paid their bills. So...

If cells in column "B" (customer name) contain the same text (same customer name), then add together corresponding values in the rows located in column "L"

P.S. I have 3,000+ rows in this excel, so I need to apply a formula to quickly give me total balances for all of these customers. THANK YOU! I LLOVE MR EXCEL!

 

[etaf]

a pivot table will do that for you
OR
if you have a late version of excel maybe filter, unique , SUMIF()

Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet. Plus we cannot see any of the formulas used.

Therefore -

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

This will possibly enable a quicker and more accurate solution for you.

MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

You can also test to see if it works ok, in the "Test Here" forum.

Test Here

Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days

www.mrexcel.com

OR if you cannot get XL2BB to work, or have restrictions on your PC

then put the sample spreadsheet onto a share

I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed

Make sure you set any share or google to share to everyone

 

[cweaver]

Hopefully this will help? Thank you!

	Customer Name	Tech #	Invoice #	Invoice Date	Division	Current	1-30	31 - 60	61 - 90	> 90	TOTAL
	$10 SHOE STORE***	27M	764259​	9/13/17	AE	0.00	0.00​	0.00	0.00	145.00	145.00
	$10 SHOE STORE***	75M	777640​	6/12/18	AE	0.00	0.00​	0.00	0.00	145.00	145.00
	1 VERTICAL INC.***	13M	844036​	10/18/22	E	0.00	0.00​	0.00	0.00	831.98	831.98
	1 VERTICAL INC.***	04M	853632​	8/12/22	TAF	0.00	0.00​	0.00	0.00	1642.50	1642.50
	10$ SHOE STORE***	77M	801459​	11/5/19	AF	0.00	0.00​	0.00	0.00	151.00	151.00
	1237 24TH ST. OWNERS ASSOC.***	04M	888527​	2/17/23	AF	0.00	0.00​	0.00	0.00	245.00	245.00
	1237 24TH ST. OWNERS ASSOC.***	10M	870193​	3/3/23	AF	0.00	0.00​	0.00	0.00	1250.00	1250.00
	1237 24TH ST. OWNERS ASSOC.***	08M	875227​	4/24/23	S	0.00	0.00​	0.00	0.00	1250.00	1250.00
	1253 E. WASHINGTON LLC***	38M	814024​	7/6/20	AFB	0.00	0.00​	0.00	0.00	125.00	125.00
	1253 E. WASHINGTON LLC***	38M	814025​	7/6/20	AF	0.00	0.00​	0.00	0.00	125.00	125.00
	1253 E. WASHINGTON LLC***	38M	817543​	10/1/20	S	0.00	0.00​	0.00	0.00	149.50	149.50
	127 WEST SOCIAL HOUSE***	244M	813784​	6/30/20	E	0.00	0.00​	0.00	0.00	116.32	116.32
	127 WEST SOCIAL HOUSE***	79M	853038​	8/26/22	E	0.00	0.00​	0.00	0.00	136.81	136.81
	127 WEST SOCIAL HOUSE***	79M	853039​	8/26/22	F	0.00	0.00​	0.00	0.00	589.28	589.28

 

[mumps]

As long as the Customer Names are all grouped together, you can use the 'Subtotal' function to do what you want.

1. On the Data tab, in the Outline group, click Subtotal. The Subtotal dialog box is displayed.
2. In the At each change in box, select Customer Name
3. In the Use function box, select Sum if it is not already there.
4. In the Add to subtotal box, place a check mark beside Total
5. Click 'OK'

 

[etaf]

heres a summary - uses unique - so need to know your version of excel, worth adding to your profile

or a pivot table as shown

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	a	Customer Name	Tech #	Invoice #	Invoice Date	Division	Current	Jan-30	31 - 60	61 - 90	> 90	TOTAL			Name	Total		pivot table
2		$10 SHOE STORE***	27M	764259	9/13/17	AE	0	0.00	0	0	145	145			$10 SHOE STORE***	290		Row Labels	Sum of TOTAL
3		$10 SHOE STORE***	75M	777640	12/6/18	AE	0	0.00	0	0	145	145			1 VERTICAL INC.***	2474.48		$10 SHOE STORE***	290
4		1 VERTICAL INC.***	13M	844036	10/18/22	E	0	0.00	0	0	831.98	831.98			10$ SHOE STORE***	151		1 VERTICAL INC.***	2474.48
5		1 VERTICAL INC.***	04M	853632	12/8/22	TAF	0	0.00	0	0	1642.5	1642.5			1237 24TH ST. OWNERS ASSOC.***	2745		10$ SHOE STORE***	151
6		10$ SHOE STORE***	77M	801459	5/11/19	AF	0	0.00	0	0	151	151			1253 E. WASHINGTON LLC***	399.5		1237 24TH ST. OWNERS ASSOC.***	2745
7		1237 24TH ST. OWNERS ASSOC.***	04M	888527	2/17/23	AF	0	0.00	0	0	245	245			127 WEST SOCIAL HOUSE***	842.41		1253 E. WASHINGTON LLC***	399.5
8		1237 24TH ST. OWNERS ASSOC.***	10M	870193	3/3/23	AF	0	0.00	0	0	1250	1250						127 WEST SOCIAL HOUSE***	842.41
9		1237 24TH ST. OWNERS ASSOC.***	08M	875227	4/24/23	S	0	0.00	0	0	1250	1250						Grand Total	6902.39
10		1253 E. WASHINGTON LLC***	38M	814024	6/7/20	AFB	0	0.00	0	0	125	125
11		1253 E. WASHINGTON LLC***	38M	814025	6/7/20	AF	0	0.00	0	0	125	125
12		1253 E. WASHINGTON LLC***	38M	817543	1/10/20	S	0	0.00	0	0	149.5	149.5
13		127 WEST SOCIAL HOUSE***	244M	813784	6/30/20	E	0	0.00	0	0	116.32	116.32
14		127 WEST SOCIAL HOUSE***	79M	853038	8/26/22	E	0	0.00	0	0	136.81	136.81
15		127 WEST SOCIAL HOUSE***	79M	853039	8/26/22	F	0	0.00	0	0	589.28	589.28
16
Sheet1

Cell Formulas
Range	Formula
O2:O7	O2	=UNIQUE(B2:B15)
P2:P7	P2	=SUMIF($B$2:$B$15,O2,$L$2:$L$15)
Dynamic array formulas.

 

[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’)

 

[cweaver]

heres a summary - uses unique - so need to know your version of excel, worth adding to your profile

or a pivot table as shown

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	a	Customer Name	Tech #	Invoice #	Invoice Date	Division	Current	Jan-30	31 - 60	61 - 90	> 90	TOTAL			Name	Total		pivot table
2		$10 SHOE STORE***	27M	764259	9/13/17	AE	0	0.00	0	0	145	145			$10 SHOE STORE***	290		Row Labels	Sum of TOTAL
3		$10 SHOE STORE***	75M	777640	12/6/18	AE	0	0.00	0	0	145	145			1 VERTICAL INC.***	2474.48		$10 SHOE STORE***	290
4		1 VERTICAL INC.***	13M	844036	10/18/22	E	0	0.00	0	0	831.98	831.98			10$ SHOE STORE***	151		1 VERTICAL INC.***	2474.48
5		1 VERTICAL INC.***	04M	853632	12/8/22	TAF	0	0.00	0	0	1642.5	1642.5			1237 24TH ST. OWNERS ASSOC.***	2745		10$ SHOE STORE***	151
6		10$ SHOE STORE***	77M	801459	5/11/19	AF	0	0.00	0	0	151	151			1253 E. WASHINGTON LLC***	399.5		1237 24TH ST. OWNERS ASSOC.***	2745
7		1237 24TH ST. OWNERS ASSOC.***	04M	888527	2/17/23	AF	0	0.00	0	0	245	245			127 WEST SOCIAL HOUSE***	842.41		1253 E. WASHINGTON LLC***	399.5
8		1237 24TH ST. OWNERS ASSOC.***	10M	870193	3/3/23	AF	0	0.00	0	0	1250	1250						127 WEST SOCIAL HOUSE***	842.41
9		1237 24TH ST. OWNERS ASSOC.***	08M	875227	4/24/23	S	0	0.00	0	0	1250	1250						Grand Total	6902.39
10		1253 E. WASHINGTON LLC***	38M	814024	6/7/20	AFB	0	0.00	0	0	125	125
11		1253 E. WASHINGTON LLC***	38M	814025	6/7/20	AF	0	0.00	0	0	125	125
12		1253 E. WASHINGTON LLC***	38M	817543	1/10/20	S	0	0.00	0	0	149.5	149.5
13		127 WEST SOCIAL HOUSE***	244M	813784	6/30/20	E	0	0.00	0	0	116.32	116.32
14		127 WEST SOCIAL HOUSE***	79M	853038	8/26/22	E	0	0.00	0	0	136.81	136.81
15		127 WEST SOCIAL HOUSE***	79M	853039	8/26/22	F	0	0.00	0	0	589.28	589.28
16
Sheet1

Cell Formulas
Range	Formula
O2:O7	O2	=UNIQUE(B2:B15)
P2:P7	P2	=SUMIF($B$2:$B$15,O2,$L$2:$L$15)
Dynamic array formulas.

Verision 16.76

 

[etaf]

not sure what 16.76 office version is ... sorry , i think possibly office 2016 , means you dont have unique()
so a pivot table would be a easy option as shown in the xl2bb i posted

 

[cweaver]

not sure what 16.76 office version is ... sorry , i think possibly office 2016 , means you dont have unique()
so a pivot table would be a easy option as shown in the xl2bb i posted

Sorry office 365, It's Excel version 16.76

 

[etaf]

ok, then you do have unique()
so can use the formula i posted - probably other as well