Hello,
I need a suggestion on how to get the following in a formula.
I would like to sum “days” associated with a particular manager. For example, I have raw data in Tab A and would like to sum the number of days (10) for “Mike Smith” and place the sum total in Tab B.
WO# Days Mgr
A1 2 Mike Smith
A2 5 Bill Tayor
A3 7 Mike Smith
A4 0 Sylvia Lake
A5 1 Mike Smith
Thank you.
I need a suggestion on how to get the following in a formula.
I would like to sum “days” associated with a particular manager. For example, I have raw data in Tab A and would like to sum the number of days (10) for “Mike Smith” and place the sum total in Tab B.
WO# Days Mgr
A1 2 Mike Smith
A2 5 Bill Tayor
A3 7 Mike Smith
A4 0 Sylvia Lake
A5 1 Mike Smith
Thank you.