I am trying to calculate a percentage of two columns and I know how to do that, but I do not want it to include the blank cell in the response. How do I go about that? Currently, my formula looks like =DIVIDE(SUM(J:J),SUM(E:E))

# Tag: I am trying to calculate a percentage of two columns and I know how to do that

I am trying to calculate a percentage of two columns and I know how to do that, but I do not want it to include the blank cell in the response. How do I go about that? Currently, my formula looks like =DIVIDE(SUM(J:J),SUM(E:E)) Thank you