I need a frmula that will sum until a certain value is reached, then start over

[mmc8267]

I am not a very advance user of Excel and would like some suggestions on how to track donations from one employee to another. I have employees that have donated time to each other, and I need to track which employees donations were given to which receiver. My beginning spreadsheet looks like this:

Donated from Hours Given Donated to Hrs Donated Total Hours Rec'vd

Caregiver B 5 Caregiver A 5 5
Caregiver C 4 Caregiver A 4 9
Caregiver D 4 Caregiver A 4 13
Caregiver E 7 Caregiver A 7 20


In this example, I would want the formula to sum the donated hours until Caregiver A has received a total of 17 hours, then the remaining 2 hours of Caregiver E's donation would be added to Caregiver F, and the formula would start over until the threshold has been reached for Caregiver F.

This information is being used to build a mail merge that will populate a separate sheet for each employee that received donations.

Thank you in advance for any assistance!

[FDibbins]

Hi and welcome to the forum

It would probably help if you provided a small sample workbook, showing what you have, and what you want

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.