Extract column total after filtering

[sofas]

Hello, I would like to extract the sum of column a after filtering. I tried to put the following formula, but to no avail =SUBTOTAL(109;a5:a1000)

Note that the values in column a are fetched from another sheet via the @Index formula

 

[Jeffrey Mahoney]

That should work except for the semicolon where a comma should be. Where the values come from is of no importance.

 

[Scott Huish]

That should work except for the semicolon where a comma should be. Where the values come from is of no importance.

Semicolons are used in international versions of Excel.

 

[Jeffrey Mahoney]

Semicolons are used in international versions of Excel.

Learned something new

 

[Jeffrey Mahoney]

Try doing a SUM on the same range and tell us what you get

 

[sofas]

Try doing a SUM on the same range and tell us what you get

I tried it and the column values came out correct. The problem is when filtering the column

 

[sofas]

Semicolons are used in international versions of Excel.

Yes, the version I have uses a semicolon. I may think that this is because the system language is French

 

[sofas]

Here is the file for preview. I tried, but unfortunately to no avail

Dropbox

www.dropbox.com

 

[Jeffrey Mahoney]

My company won't let me use dropbox

 

[Burrgogi]

Not sure if I understand you correctly. Are you trying to subtotal cells A5 thru A1000, and add 109? If so, then have you tried placing the 109 outside of the parenthesis like so:

=SUBTOTAL(A5:A1000)+109