On Thu, 11 Dec 2008 12:00:05 -0800, Kevin
wrote:

Well, that works and I like it, however when I stated my example I simplified
it thinking I could change the formula prett easy. In actuallity the cells
that need to be added are
C4, E4, G4, I4, K4, M4, O4, Q4, S4, U4, W4, Y4, AA4, AC4, AE4, AG4

One way:

=SUM(RegexMid($C$4,"[^,]+",ROWS($1:1)),RegexMid($E$4,"[^,]+",ROWS($1:1))),...)

But doing it all within a UDF would probably be simpler.
--ron