How would I create subtotal rows in a table? A true table, I dont want to turn my table into a range because I need the other sorting features.

Posting as :
works at
You are currently posting as works at

Not sure if this will answer but if you go to design tab of table mark total row, then click drag to fill under the columns you want totaled.


Subtotals will break your table, have to convert back to a range. There is the handy total row you can turn on with check box on the table design tab though.


As BCG said they don’t really support true subtotal rows, other than the Grand Total row at the bottom (which is a subtotal formula that updates when you filter). If your table isn’t too dynamic and the groups that you’re summing are known, you could go below or to the side of the of the table and do a fairly complicated array formula for each group, which would involve Sumproduct, Subtotal, Offset, and Min. You can find examples if you google “Subtotal if”


For summing sub totals including only what’s filtered in your table at a given time, use the 109 code in the subtotal formula


You could cheat and create a pivot table that just recreates the original range, except this time you can add subtotals.

If you mean the SUBTOTAL function, just turn the table into a range, select the header row and then Ctrl-Shift-L (this turns on the filters, they work pretty much like in a table). You can then add subtotals on the top, so that every time you filter the range the formula will show the sum/average/etc of the filtered range




Use the existing total row as others have said, then additional value columns that zero out based on criteria you'd want to filter on (e.g. col c = value if col a = US, col d = value if col a = UK, etc)

You might try this:

Related Posts

Do you usually go out to lunch, eat at your desk, bring food from home, or something else?


Hello from the other siiiide! D—> BCG lets goooo


A Friday type discussion? Do only bjiou sales pepele drink Topo Chico now? My local Mexican grocery store is charging $5 more for a 12 pack than Whole Foods?


As AI practitioners, what do we think about singularity and simulation theory? Have come to the recent profound thought that as a technology loving human, my purpose on earth is to push myself and my work closer towards the AI-Human synchrony (driverless cars, wearable tech, neuralink, smart home, etc)


I feel like a mega nerd saying this but I just got staffed on my first data breach response and I'm having so much fun! 🥸😅


Hiya! I was wondering if anyone here has any good recommendations in terms of books or learning material that I can pick up to learn about sales and marketing relevant to the consulting industry?


How much MossAdams charges for a morerate 1040 filing which has crypto transactions?

I’m really trying to break into Tech Strategy / Product Strategy…would anyone be willing to review my resume? Im open to whatever feedback you have and would be very grateful!


How long after your i140 approval can you quit the company? Is it 180 days from date of i140 filling?

I need 11 likes to start DM


Has anyone ever had to request a waiver from a client during the conflicts process? If yes, how was the process handled?


Any good utilities for creating charts for print? I hate creating charts, been doing it forever in my line of work, but Excel forget it, and the AI chart tool isn’t great either. Any alternatives?


Can someone refer me for job id 356925WD

I wish I had a person I could talk to everyday. Life after college is so damn boring!!!!


Entry level consultant from South America starting in the US. Tried to search for it but couldn’t find so 🐠 please tell me some basic dos and donts of being well dressed here in America.

Links to any


I have two offers

1) guardian life : 17.5 lpa

2) citiustech: 17 lpa fixed +1 lakh variable

what should i consider ?

Can anyone share reviews these two companies?


So the vaccination numbers are low for the fed gov, especially the intelligence community. They already pushed the vac deadline date once. What do you think will happen? Can’t fire 30% of the government.


Which consulting companies are offering the last week of December off for the holidays?


Anyone know any influencers or websites that has good recipes for woman with gestational diabetes?


Additional Posts in Excel Genius

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.


I love Excel, but I have a lot to learn. My brother said his company needed to hire someone to revamp a workbook. I've been wanting to take a course to improve my skills, so I told him I'll look into learning more about macros and maybe they could hire me. Where is the best place to find good courses?


How do you create a Pareto chart in excel? Like I want to identify what percentage of customers contribute to 80% sales. I have data at individual customer level.


Any macro experts that can help changing this 3 generation family tree generator to a 6 generation one (template link provided in comment below)? Provided by Microsoft but I have no idea how to edit this macro to allow more generations, and this is the easiest to generate template I've seen unfortunately


My sheet has multiple cells with Notes. Whenever I reorder rows or add new columns, the notes go completely out of whack (get displaced or squeezed). Any quick fixes? Also why does this happen?

What other function can I use for a multi criteria sum aside sumifs?


Google Sheets vs Excel - pros and cons? Asking seriously.


Whenever I press Enable Content, Excel crashes (and does an infinite loop). I can’t seem to break link the cell that is supposedly linked to an external source. Anyone know how to solve this?


Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it


Hi all, urgent request for help:

Say I have two rows (New and Lost customers) and a bunch of columns for the number of months passed. I can input a specific number of months that customers get retained for (X), and to calculate lost customers each month I want to subtract the new customers from X months ago. What formula do I use to grab the value X months ago from the New row? I want to make sure that the value I grab can change based on the X input. Manual example below.

Post Photo

I’m experiencing a delay when I switch between different workbooks where it would take at least 5 seconds until I can click into the new workbook. I’m losing productivity especially when I’m doing a copy and paste task between different spreadsheets. Anyone else experienced this before and know any potential solutions?


What macros do y’all have set up?


Alternatives to Power BI for Mac users? Trying to branch out of excel. Reports aren’t too stable with excel


Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!


Need help tabulating survey results. Each row is a respondent, but the question asks “choose all that apply” resulting in several columns associated with that one question. How can I get a distribution for which answers were chosen among the top 3?


Excel geniuses, is there a template one can use to have numbers in excel output in ppt? Looking to build some basic daily operational dashboard? TIA


Is there a way to color a cell based on the color of another cell? I have Sheet one with green, yellow, red used to denote progression status on 20 tasks, which constantly changes based on client input. Sheet 2 is a summary dashboard of each of those 20 tasks. If sheet1 C3 is green, how can I get the respective sheet 2 dashboard cell to also turn green?


Is there any big advantage of using gsheets over excel?


Why does my excel always freeze when I copy a cell?


I have two sperate sheets, i need to extract volume and cost from the second to the first sheet, but they have to match the criteria like origin/destination, packaging type, what can i use to do so?


New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here


Embed this post

Copy and paste embed code on your site


Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or