=SUBTOTAL(9,$E$24:E25)-SUBTOTAL(9,$F$24:F25) The subtotal is the function which update the sum of number is the filter is done.
See the attached file of the clear understanding. When you drag the formula,As e24 ref. is absolute it won't change. remaiming refrence keep on changing. Warm Regards Bhushan Sabbani +91 98208 26012 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Subtotal.xls
Description: MS-Excel spreadsheet