Nov 22 2022 06:18 AM
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.
Nov 22 2022 07:21 AM
Nov 22 2022 07:58 AM
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)