Forum Discussion
SemiInc
Jan 23, 2020Copper Contributor
Totaling Filtered Cells
So I have a question about totaling cells that have been filtered. What I need Excel to do is, once filtered, total the corresponding $ amount column. I have enclosed a very simple example. Anybody have the answer for me? Thanks in advance. Figured it out!!!
1 Reply
- Though, I can only see horz in column F and vert in column I with Bits as the heading. Though the sample data looks insufficient to me.
However, I believe PivotTable should be able to do exactly what you intend.. You can try that on your main data