Hello everyone,
I am trying to add a filtered list but only if the cells of another column have a value >0.
So in my screenshot (I have also attached a spreadsheet) the list has been filtered I need cell F35 to add but only from the filtered list and only if the filtered data in column J is >0. F35 therefore should be adding up the green cells in column F because they are the ones that have a figure in column J.
Basically only add up the cells in column F if there are figures in the same row in column J.
SShot.jpg
Bookmarks