Forum Discussion

SemiInc's avatar
SemiInc
Copper Contributor
Jan 23, 2020

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

Resources