Excel User Group

Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Sign in | Join | Help

Daily Dose of Excel » All Tags » Counting and Summing Functions (RSS)

Browse by Tags

Daily Dose of Excel

Home

Syndication

Recent Posts

Subtotals Ignoring Subtotals

Tags

News

This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika

Archives

Sorry, but there are no more tags available to filter with.

Subtotals Ignoring Subtotals

Recently I got a workbook with this formula: =F57+F52+F43+F35+F25+F16+F10+F8+F59+F61+F60 I’m sure you’ve seen a few formulas like this. I know I have. I may have even made one or two. There is a better way, however. Usually a formula like this means there are several lists in the column with subtotals and this [...]

Published Fri, Jan 01 2008 1:53 PM by Daily Dose of Excel

Filed under: Counting and Summing Functions

Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.