Getting the sum from filtering

  • Thread starter Thread starter Jason V
  • Start date Start date
J

Jason V

I am trying to filter on a column and then I want to sum the result of the
visible rows. How do I fo this in code?

Thanks
 
I am still having trouble. Here is a sample spreadsheet

Green 2
Green 2
Blue 3
Red 4
Green 3

I want to filter on green and then sum the values (7) and then assign the
sum to a variable. I do not know the unfiltered range because it will
continue to grow. Do I select the whole column then?

Thanks
Jason V
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sums, Filters and Events oh my! 2
sum a range 1
Multiple SUM's in a column 15
lastrow function help 6
sum visible amounts 2
VBA code to Fill Down in a filtered list only to visible cells. 1
How to set range to autofiltered visible cells? 7
Using formulas along with Auto Filters 1

Back
Top