I am trying to add visible cells in a column. I'm using subtotal for this. Then if one of the cells within that column that is visible is less than 1 I was want to add a cell from a different column. I'm trying to make apples to apples of two columns, if that makes sense. I for some reason am stuck on this...
Column 1 (visible rows only) Column 2 (visible rows only)
50 45
30 27
75 0 (I want this to become 75 so that when summed I'm comparing the same scope)
Total Total
155 147
Thank you for any help.
Column 1 (visible rows only) Column 2 (visible rows only)
50 45
30 27
75 0 (I want this to become 75 so that when summed I'm comparing the same scope)
Total Total
155 147
Thank you for any help.