Formula to sum a list of accounts

[Grepees]

I want to write a formula that would sum a list of accounts in column J and return the number 14,715. These accounts will be updated over time and i would love to add to the list in J, and have my formulated automatically sum it IF the list is updated. Another help would be very much appreciated. Thanks.

 

[etaf]

not sure i follow
JUST add a SUM(K6:K14)
and that will do a sum of the K column

Not sure what you are doing with the account number

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 good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

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

 

[Grepees]

not sure i follow
JUST add a SUM(K6:K14)
and that will do a sum of the K column

Not sure what you are doing with the account number

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 good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

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

apologies, i wasn't clear... in the list of accounts are also accounts that i do not need in my sum. The question really was how to selectively sum the accounts of accounts i need. Does that help? Thanks.

 

[etaf]

What version of excel are you using - would be worth updating your profile to show version as solutions will be dependant on what version you have and therefore what functions available.
Excel Versions are: 2003/2007/2010/2013/2016/2019/2021/2024 (due April24) /365 subscription , also rather than show more than 1 version . if you have them , show which version you will be using the solution for.
An awful lot of new functions have now been added to the newer versions

would you have seperate list of the accounts you want to sumup

=SUM((SUMIFS(K6:K14,J6:J14,E2:E8)))
where E2:E8 - can change the column and position
is a list of accounts

Sum with an Include List.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1					LIST TO SUM
2					1234
3					127
4
5											Account
6											1234	100
7											5678	200
8											9102	300
9											126	400
10											127	500
11
12
13
14
15												600
Exclude (2)

Cell Formulas
Range	Formula
L15	L15	=SUM((SUMIFS(L6:L14,K6:K14,E2:E8)))

 

[Grepees]

What version of excel are you using - would be worth updating your profile to show version as solutions will be dependant on what version you have and therefore what functions available.
Excel Versions are: 2003/2007/2010/2013/2016/2019/2021/2024 (due April24) /365 subscription , also rather than show more than 1 version . if you have them , show which version you will be using the solution for.
An awful lot of new functions have now been added to the newer versions

would you have seperate list of the accounts you want to sumup

=SUM((SUMIFS(K6:K14,J6:J14,E2:E8)))
where E2:E8 - can change the column and position
is a list of accounts

Sum with an Include List.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1					LIST TO SUM
2					1234
3					127
4
5											Account
6											1234	100
7											5678	200
8											9102	300
9											126	400
10											127	500
11
12
13
14
15												600
Exclude (2)

Cell Formulas
Range	Formula
L15	L15	=SUM((SUMIFS(L6:L14,K6:K14,E2:E8)))

Thank you very much. It worked.

 

[etaf]

You are welcome
remember to update profile of version you are using , as often easier functions to do things in later versions