I am putting together a spreadsheet that will calculate totals in each column. In one of the columns I have totals paid to date for each row. I am trying to find the sum of those cells (rows 2 through 30) and then divide the sum against a total from another cell. How can I do that? I have tried the formula =SUM(P2:P12)/L13 but I get an error.

Is this even possible? It seems logical but I cannot figure out how to resolve the error.

Thank you,

Regina