User Help Web Apps

How do I use isblank formula with the divide function?

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

Leave a Reply

Your email address will not be published. Required fields are marked *