Marcus Aurelius
asked on
Excel "Dynamic SUM" when Grouping / Hiding Data....?
I have columns of data that have a SUM TOTAL "ie..SUM(a10:a2000)"
I would like to filter on a column and then have this TOTAL SUM ONLY THE FILTERED ITEMS....
How do i do that.....?
As it stands now.,..when I filter the Total for ALL rows is still showing in the total cell. What syntax or code do I use in the total cell so that it will ONLY summarize the FILTERED data rows..?
I would like to filter on a column and then have this TOTAL SUM ONLY THE FILTERED ITEMS....
How do i do that.....?
As it stands now.,..when I filter the Total for ALL rows is still showing in the total cell. What syntax or code do I use in the total cell so that it will ONLY summarize the FILTERED data rows..?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.