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
 
Back
Top