Sum amount of days in another coloumn
Sorry, i have it working now...the dtae coloumn had a title in it.
"Scott_goddard" wrote:
Hi thanks for this but i can not seem to get it to work....does it matter
that i am not using 2007 - it just returns a value error
"Jacob Skaria" wrote:
Try the below
ColD and Col E contains dates...
=SUMPRODUCT((A1:A10={"Analysis","Develop"})*(E1:E1 0-D1:D10))
--
Jacob (MVP - Excel)
"Scott_goddard" wrote:
Hi all,
I am using the below spread sheet
Task Working days Start date End date
1 7 days 28/05/2010 07/06/2010
Analysis 1 2 days 28/05/2010 31/05/2010
Develop 2 1 wk 01/06/2010 07/06/2010
2 4 days 01/06/2010 04/06/2010
Analysis 1 1 day 01/06/2010 01/06/2010
Develop 2 3 days 02/06/2010 04/06/2010
3 7 days 02/06/2010 10/06/2010
Analysis 1 2 days 02/06/2010 03/06/2010
Develop 2 1 wk 04/06/2010 10/06/2010
I need to calculator the amount of working days based on if the days are for
analysis or development. I would like to return the value in one cell for
development and analysis work? Any one now how to do this?
|