J
Jason
I have the following type of data.
Column A
1 =sum(A3:A6)
2 'Amount
3 $5,000
4 $2,000
5 $1,000
6 $500
As you can see, I have some values in a column for which
I would like to show the sum of in Cell A1. I also have
a filter applied to the range (A2:A6). When the filter
is selected as "all", the sum in cell A1 is $8,500.
However, if I were to filter based on "values > $1,500"
(and thus only show the values in cells A3 and A4) , the
value that is produced from the formula in cell A1 still
gives me $8,500 instead of the $7,000 I would like to
see. How can I get the result of only summing the values
that are included in the results of the filter? Thanks
for your help.
Jason
Column A
1 =sum(A3:A6)
2 'Amount
3 $5,000
4 $2,000
5 $1,000
6 $500
As you can see, I have some values in a column for which
I would like to show the sum of in Cell A1. I also have
a filter applied to the range (A2:A6). When the filter
is selected as "all", the sum in cell A1 is $8,500.
However, if I were to filter based on "values > $1,500"
(and thus only show the values in cells A3 and A4) , the
value that is produced from the formula in cell A1 still
gives me $8,500 instead of the $7,000 I would like to
see. How can I get the result of only summing the values
that are included in the results of the filter? Thanks
for your help.
Jason