## Sum a filtered column

To sum a column use: =SUM(A1:A20). But what if the column is filtered?

As you can see , in the picture below, the sum function sums all the values, even the ones filtered out. To solve this problem use: =SUBTOTAL(9,A1:A20)

Functions:

=**SUM(**number1;[number2];...**)
**Adds all the numbers in a range of cells

** =SUBTOTAL(**function_num;ref1;...**)
**Returns a subtotal of a list or database

### Category: Sum function

Identify numbers in sum using solver

Here is a useful feature I recently found googling for Excel solver examples. I have summed some random values from […]Comments(48) Filed in category: Combinations, Excel, Solver, SUM function

Sum values between two dates with criteria in excel

In this post, I will provide a formula to sum values in column (Qty) where an column (Date) meets two […]Comments(27) Filed in category: Excel, SUM function

Sum values in a range where adjacent cell value equals a criterion in excel

Question: How do I sum all values in a range where adjacent cell value equals a criterion? The criterion is […]Comments(19) Filed in category: Excel, SUM function

Comments(13) Filed in category: Excel, MMULT function, Permutations, SUM function

Comments(7) Filed in category: Count values, Excel, MMULT function, SUM function

Excel udf: Find positive and negative amounts that net to zero

I created/modified an udf to solve his question: Find positive and negative amounts that net to zero in excel Question:I would […]Comments(5) Filed in category: Excel, SUM function

Comments(2) Filed in category: Check-boxes, Excel, SUM function

Excel udf: Find numbers in sum

This article describes how to find a sum from a range of numbers using a user defined function. Let´s see […]Comments(2) Filed in category: Excel, Finance, SUM function

Comments(2) Filed in category: Excel, SUM function

Sum adjacent values using multiple lookup text values in a column in excel

Here is a follow up to this previous post: Vlookup with 2 or more lookup criteria and return multiple matches […]Comments(1) Filed in category: Excel, SUM function, Vlookup