# excel summing column

#### alliswell

##### Board Regular
statement.xlsx
ABCDEFG
1DateNameBalancejimDateBalance#N/A
201/04/2020George20016/04/2020346
301/04/2020George350#N/A#N/A
401/04/2020Samuel950#N/A#N/A
503/04/2020Tim500#N/A#N/A
603/04/2020John650#N/A#N/A
704/04/2020John235#N/A#N/A
805/04/2020George790#N/A#N/A
905/04/2020George655#N/A#N/A
1005/04/2020George150#N/A#N/A
1108/04/2020Tim222#N/A#N/A
1208/04/2020Tim315#N/A#N/A
1310/04/2020John575#N/A#N/A
1410/04/2020John524#N/A#N/A
1510/04/2020Samuel199#N/A#N/A
1610/04/2020Samuel165#N/A#N/A
1714/04/2020Samuel65#N/A#N/A
1815/04/2020Chris112#N/A#N/A
1916/04/2020George455#N/A#N/A
2016/04/2020Jim346#N/A#N/A
2118/04/2020Tom990#N/A#N/A
2220/04/2020George915#N/A#N/A
2320/04/2020George392#N/A#N/A
2421/04/2020John211#N/A#N/A
2522/04/2020Sam119#N/A#N/A
Sheet1
Cell Formulas
RangeFormula
G1G1=SUM(F:F)-F1
E2:E25E2=INDEX(A:A,\$J2)
F2:F25F2=INDEX(C:C,\$J2)
Press CTRL+SHIFT+ENTER to enter array formulas.

whenever i input name in d1 i get statement in e2 and f2. i want sum of F column in G1. i applied formula but isnt working pls check.

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### GraH

##### Well-known Member
Please update your XL2BB output as you have J2 in your formula, but column J is not visible here.

#### Fluff

##### MrExcel MVP, Moderator
If you just want the total for Jim, try
Excel Formula:
``=SUMIFS(C:C,B:B,D1)``

Replies
2
Views
245
Replies
2
Views
265
Replies
7
Views
784

1,191,199
Messages
5,985,234
Members
439,952
Latest member
djharter

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back