Sum a column where the cells are based on calculation. HELP

[blpen]

Hi,

Need help in creating a sum for a column.
The column is a result of a calculation. The C3 cell has a date in it
showing when the person became a member. The Cell next to it shows the
result of the calculation in years and months.

the calculation works fine fore what I need. It is as follows:
=IF(D3="","",DATEDIF(D3,TODAY(),"Y")&"."&DATEDIF(D3,TODAY(),"YM"))

Now what I want to do is to sum the column that is the result of the
calculation. Showing in years and months, the total time they have been
members, Average the sum of members,

Can anyone help me do this. I have been playing around with the sum
function but I am doing something wrong.

Thanks
blpen

 

[Mike Fogleman]

An array formula will do it.

{=SUM(VALUE(E3:E23))}
Type the formula without the braces and hit Ctrl+Shift+Enter. Excel will put
the braces around the formula.

Mike F