Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-13-2013, 01:53 AM
Kevin@Radstock Kevin@Radstock is offline Sum on AutoFilter Windows 7 32bit Sum on AutoFilter Office 2010 32bit
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Hi Grasshopper

Use the SUBTOTAL function. I personally would insert a row above your data and put column headers ie: Month & Sales. So your filters will be in these cells.

Then in B1: =SUBTOTAL(109,$B$3:$B$103)

Edit: Forgot to add that you could also use a Pivot Table. See the attached file.

Kevin
Attached Files
File Type: xls 002-Sum on AutoFilter.xls (36.5 KB, 15 views)
Reply With Quote
 

Tags
autofilter, autosum



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum on AutoFilter AutoFilter Criteria3 coxjamd Excel Programming 2 01-17-2013 02:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:52 PM.


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