Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-12-2018, 08:56 AM
excelino excelino is offline SUBTOTAL FUNCTION PROBLEM when add a new line on top Windows 10 SUBTOTAL FUNCTION PROBLEM when add a new line on top Office 2000
Novice
SUBTOTAL FUNCTION PROBLEM when add a new line on top
 
Join Date: May 2018
Posts: 2
excelino is on a distinguished road
Unhappy SUBTOTAL FUNCTION PROBLEM when add a new line on top


Hello,
I use at cell C1 this function

=SUBTOTAL(9;(C2:C12))

If I add a line at the top and the data from C2 qoes to C3 ecc the new data at C2 it's not be calculate by the function.

I'm not sure if I explain well, because my English it's really bad, but I want to keep the function ordel also when I add a new line so from

=SUBTOTAL(9;(C2:C12))
-----------------------------> NEW LINE C2
=SUBTOTAL(9;(C2:C13))
ecc

is this possible?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
2016 Excel Subtotal Function Changed CindyPauls Excel 0 08-31-2017 11:44 AM
SUBTOTAL FUNCTION PROBLEM when add a new line on top Problem with Value function misokol Excel 3 01-11-2017 08:59 AM
Problem with function PRA007 Word VBA 2 01-13-2016 01:11 AM
SUBTOTAL FUNCTION PROBLEM when add a new line on top Function problem li roy Excel 2 02-18-2012 02:44 AM
Each subtotal signature require only at last page for each subtotal. aligahk06 Excel 0 05-07-2010 11:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft