Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |