I have an Excel sheet that I use for my P & L statement. I would like to calculate the percentage of revenue and cost on each line from my gross revenue. It is a 12 month P & L with about 45 lines for each month that have cost and revenue numbers. I need the percentage of gross sales for each line and the only way I know how to do it is to do each cell one by one. 45 x 13 (includes yearly as well) is just less than 600 cells I would have to do this for. My question is, is there an easier way to do this. If needed, I will attach a screenshot to better explain. Thanks in advance for any help.