Sum up visible data rows

A

adamsm

Active Member
Joined
Apr 20, 2010
Messages
444
Hi,

The following code formula sum ups all rows. How could make it to sum up only visible rows?

Code: 
.FormulaR1C1 = "=SUM(R1C:R[-1]C)"

Amy help on this would be kindly appreciated.

Thanks in advance.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
Check out the =SUBTOTAL() function.

Has 2 arguments, the first one is the type of subtotal and I think it should be 109 for visible rows only. Second arg is the range.

Code: 
.FormulaR1C1 = "=SUBTOTAL(109,R1C:R[-1]C)"
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Division only to visible cells
Replies
2
Views
103
damav78
D
P
  • Question Question
Column Sum problem
Replies
7
Views
149
Peter_SSs
Peter_SSs
T
  • Solved
Spilled array formula
Replies
3
Views
147
tana
T
M
  • Question Question
Summing Up only the Weekend Days from the Total
Replies
3
Views
150
Alex Blakenburg
A
N
  • Solved
Find next visible cell, add a formula and then fill column down
Replies
8
Views
398
MARK858
MARK858

Forum statistics

Threads
1,224,514
Messages
6,179,220
Members
452,895
Latest member
BILLING GUY

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top