I want to delete rows in a table where cells after column E (listcolumns(5)) are blank.
Initially I used the following:
However it fails if there are positive and negative values that cancel each other out as this data needs to remain. It also wasn't addressing the tabe but that's something I'm going to sort shortly.
So I need to change from a Sum to a CountIF however the following does not work (argument not optional):
This did not give any error but rsum always has a value of empty:
I could loop through each Listrow to determine if all cells are blank but this wouldn't be efficient.
Can anyone advise what I've missed/done incorrectly?
Bookmarks