How to I Total Number in a column for a specific number of rows

S

sburch032870

New Member
Joined
Jul 20, 2013
Messages
29
I need to insert a formula that will allow me to total the rows below based on the number placed in another location. For instance I want to insert a subtotal group in a row and I want the total of the rows below that to be in my subtotal. But I will not know how many rows I will have until I enter the value in the specified cell.

Or I could use a formula or macro that totals the until it hits an empty row in the specified column.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Sort by date Sort by votes
=SUBTOTAL(x,INDIRECT("$A$1:$A$"&y) where x is the subtotal you want to use and y is the cell you will input the value to tell it how many rows to look down for its calculation.
 
Upvote 0
Thank you for the attempt but it did not work. I am sure that I did not explain it correctly, it was trying to do something but just not what I was looking for.

Attempted image removed by Moderator
 
Upvote 0
To show a small screen shot, see my signature block below for alternatives & place to test.
 
Upvote 0
Sorry about that, new to this, thought that I could drop a screen shot in and make my questions make some sense... :)
 
Upvote 0
sburch032870 said:
Sorry about that, new to this, thought that I could drop a screen shot in and make my questions make some sense... :)
Click to expand...
No problem, but I'd still recommend testing the methods I suggested (unless using a Mac) as potential helpers cannot copy from your images and they generally do not like typing out test data - much easier to copy/paste. :)
 
Upvote 0
Thank you for looking, I don't really care what it is or how it functions, I am don't even think I really understand the difference. I am just trying to be able to create a template subtotal row and insert it with everything ready to go then just tell it how many rows it needs to subtotal. If that makes sense?
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
Add total row with a loop
Replies
4
Views
140
gberg
G
D
  • Solved
Sum visible only rows based on different column/cell value
Replies
8
Views
253
Fluff
Fluff
T
  • Question
VBA Calculated Field - Subtract Value in Data Field from Value in Row Field
Replies
0
Views
216
th259
T
R
  • Solved
VBA - Summing a dynamic gap range between two named ranges?
2
Replies
13
Views
357
RockandGrohl
R
P
  • Question
Delete Rows down to a String
Replies
7
Views
206
mumps
mumps

Forum statistics

Threads
1,214,945
Messages
6,122,397
Members
449,081
Latest member
JAMES KECULAH

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