Forum Discussion
Sum of group of cells Divided by Sum of another group of cells
I am trying to divide the sum of a group of cells by the sum of another group of cells. I need to add cells AJY-AKD in row 9 and then divide that number by the sum of cells AJY-AKD in row 17. ...
maybe =SUM(AJY9:AKD9)/SUM(AJY17:AKD17)
and you could add that IFERROR like you did in the example:
=IFERROR(SUM(AJY9:AKD9)/SUM(AJY17:AKD17),0)
and you could add that IFERROR like you did in the example:
=IFERROR(SUM(AJY9:AKD9)/SUM(AJY17:AKD17),0)
I forgot to mention that the data is being pulled from another workbook entirely. I think I was finally able to figure out the formula. I will post it in case it helps anyone else out! mtarler
=SUM('[Workbook Name.xlsx]Sheet1'!$AJY$9:$AKD$9)/SUM('[Workbook Name.xlsx]Sheet1'!$AJY$17:$AKD$17)