title: How to look for values with % in a column and then sum them up and place it in an empty row?
body: <p>I was wondering if there is any method that could detect a column with %? After that, sum the rows that have the %?</p>
  
  <p>For example, in the following, i have a picture, Column B -D has values that contents %. The total % in B will be 130%, C will be 105%, D will be 90%. The total will be place at the subsequent empty row, for this particular example, will be row 8. I need the row to be flexible as it may end up more than 8.</p>
  
  <p><img src="https://i.stack.imgur.com/xyCoD.png" alt="enter image description here"></p>
  
  <p>I hope someone understands what i'm trying to convey here. What i'm trying to do is to look for the % and sum them up, the total will be placed at the subsequent empty row.</p>