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

B

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select and sum all numbered cells in Column A 2
Calculating time between mulitple dates 4
Sum a range of cells based on relative position 3
Date since hired displayed in years.months 1
Sum values based on criteria in another column 4
Conditionally sum a column of numbers based on color. 1
Calculation on a range problem 3
Update Upon Opening based on DATEIF NOW() 10

Top