Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum a column where the cells are based on calculation. HELP
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(D 3,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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum a column where the cells are based on calculation. HELP
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 "blpen" wrote in message ... 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(D 3,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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to do a calculation based on the values in two cells | Excel Worksheet Functions | |||
Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
Calculation based on entry into one of 2 cells | Excel Programming | |||
calculation based on row and column values | Excel Programming | |||
Populating cells based on calculation | Excel Worksheet Functions |