Grand Total Macro for All Individual Total Account

[Warmhearted]

Hello,
Below is just a sample short list of my long list of accounts that I have to manually grand total in cell F4 for all individual total accounts. Could you please help creating a macro that performs this calculation? Thanks for your help!

BankStatements2020.xlsm
	A	B	C	D	E	F	G
1	Chase Bank Feb-2020				Acct# 0000 0000 0000
2					1.800-000-0000
3	Algona				MRR
4	40	4.30	11-Feb-20		Grand Total	804.32
5	40	17.10	24-Feb-20
6	40	78.30	28-Feb-20
7		99.70
8
9	Auburn
10	45	12.70	03-Feb-20
11	45	91.59	10-Feb-20
12	45	23.40	13-Feb-20
13	45	110.46	28-Feb-20
14		238.15
15
16	Bellevue
17	50	49.05	03-Feb-20
18	50	15.00	18-Feb-20
19	50	159.43	20-Feb-20
20	50	16.39	24-Feb-20
21	50	145.40	27-Feb-20
22		385.27
23
24	Black Diamond
25	60	0.70	05-Feb-20
26	60	2.70	25-Feb-20
27	60	28.45	25-Feb-20
28		31.85
29
30	Boulevard Park
31	80	24.70	04-Feb-20
32	80	0.60	25-Feb-20
33	80	24.05	25-Feb-20
34		49.35
Sheet1

 

[pjmorris]

You don't need a macro, try this in the cell you want the grand total:

=SUMIFS(B2:B32,A2:A32,"<>",B2:B32,"<>")

The real answer is to pull the data into PowerQuery and present it using PowerPivot, the combination is so much more powerful and flexible.

HTH

 

[Michael M]

You don't need a macro.
Why not just use

=SUMIF($C$4:$C$34,"<>",$B$4:$B$34)

 

[Warmhearted]

Thank you Michael M! It works perfectly. I just replace number of cell B to reflect my real account. I run a macro, and the last step is to grand total all accounts, so, that why I need to add this step to my current macro. Do you have any idea? Thanks!

 

[Warmhearted]

You don't need a macro, try this in the cell you want the grand total:

=SUMIFS(B2:B32,A2:A32,"<>",B2:B32,"<>")

The real answer is to pull the data into PowerQuery and present it using PowerPivot, the combination is so much more powerful and flexible.

HTH

Thank you pjmorris! It works perfectly. I just replace number of cell A and B to reflect my real account. I run a macro, and the last step is to grand total all accounts, so, that why I need to add this step to my current macro. Do you have any idea? Thanks!