Amount divided by how many time the ID repeats

[Elva_Tanguerre]

Hello, I am looking for a formula that will divide the total amount by as many time as the gift ID is present. For instance, donor 1 is present three times, so the $900 should be divided by 3 and return $300 for each row. For donor 2, the $500 would be divided by 2 as it is present twice for a return of $250 in each row. Etc. The spreadsheet wont' be sorted by ID like below though.  Thanks!

Gift ID	Name	Real Amount	Total
984	Donor 1		$ 900.00
984	Donor 1		$ 900.00
984	Donor 1		$ 900.00
123	Donor 2		$ 500.00
123	Donor 2		$ 500.00

[#2 · Accepted solution]

@Elva_Tanguerre Perhaps like this? (Used good old VLOOKUP as I don't know if you have access to newer functions like XLOOKUP).

[#3]

Thanks. Makes sense, I did not even need the vlookup - I just selected the Total amount cell.