Hi,
I want to sum the man years for five persons.
Lets say cell A1:A6 is:
A1:01.02.2003
A2:04.05.2006
A3:07.08.2009
A4:10.11.2012
A5:blank
A6:02.01.1999
=∑(YEAR(NOW())-YEAR(A1:A6))?
How can this be written in excel? Cell A5 is blank.
Franz
Hi,
I want to sum the man years for five persons.
Lets say cell A1:A6 is:
A1:01.02.2003
A2:04.05.2006
A3:07.08.2009
A4:10.11.2012
A5:blank
A6:02.01.1999
=∑(YEAR(NOW())-YEAR(A1:A6))?
How can this be written in excel? Cell A5 is blank.
Franz
Last edited by franzzo; 08-12-2013 at 08:42 AM.
Hi
could be please be more specific ? Post a sample sheet showing desired results - Thx
=SUM(IF(A1:A6<>"",YEAR(TODAY())-YEAR(A1:A6)))
Confirm Control+Shift+Enter
If you are happy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
That did not work on my spreadsheet. I have attatched it to this thread.
Nothing attached
Why it did not work?
I dont know. The file is attatched now. It is my first post, sorry. Cell A5 should be empty.
This is array formula
Confirm with COntrol+SHift+Enter not just Enter.
(Press and hold Control+Shift then press Enter)
You have to put the insertion point in the formula bar before committing as described in post #8. The formula will then be between curly braces. Adding them manually will NOT do.
It worked! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks