Hi just got this to work - sort of. The problem i now have is the col A
contains loads of different titles for different pieces of work and i think
this is causing the Value return. Should this be a problem?

"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?