bradford factor calculation across multiple rows

i’ve recently started a HR role where they calculate bradford factor scores by hand (if you don’t know bradford factor scores are a form of absence management that follow this formula: instances ² X days

they download a report and export it into excel. this puts each instance in a seperate row (so if a person has 3 instances of absence there will be 3 rows with their name in). there is then a column that has the days for each instance. at the moment we have to go through the whole document and calculate each persons score by hand

is there a formula i can apply that will be able to identify the multiple instances across rows, square the total and then multiply it by the sum of the days across those instances?

i have a basic understanding of excel so this is very out of my skill set. if i have explained it poorly please let me know and i can try again. TIA!