My subtotal and sum

		Microsoft Office Forums > Microsoft Excel > Excel
My subtotal and sum

FAQ

Thread Tools

Display Modes

01-17-2015, 07:10 AM

Anmol786

Windows XP My subtotal and sum

Office 2007

Novice

Join Date: Jan 2015

Posts: 1

My subtotal and sum

sirs

Is there any formula in excel or VBA for this

if i write SUBTOTAL in A3 then a sum total of given range appears in B3

likewise if i write SUBTOTAL in B6 then a sum total of given range appears in C6

i have attached a sheet for details

plz help

Attached Files

Series.set.xlsx (7.4 KB, 11 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with Subtotal(103, ) formula and blank cells	zhl203	Excel	1	07-30-2014 03:40 PM
Filter, Subtotal & display	mwrother	Excel	2	03-14-2014 01:52 PM
Pivot Tables - Values divided by Subtotal	Loretti	Excel	0	11-12-2012 02:15 PM
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 06:30 PM.