Hi Biff,

Thanks for your quick response. The multiple values are in the same cell, so
your second suggestion works well. However if I am trying to sum across a
range, I am stuck. I am not sure if there is a way to put this formula into
another one to get it to function across a range. For example:

Jan Feb Mar
Kevin Proj1, Proj2 Proj1, Proj2 Proj1, Proj2
John Proj1 Proj1 Proj1
Paul Proj1, Proj2, Proj3 Proj1, Proj2 Proj1, Proj2

Proj1 1.8 1.8 1.8
Proj2 0.8 0.8 0.8
Proj3 0.3 0.3 0.3

Thanks,

Randhir