Formula Assistance

[jstevens]

I am trying to determine the correct formula based on whether or not an individual is full-time or part-time and termination month.

The attached workbook provides the details and expected results. I'm just not sure how to formulate it.

Thanks for taking a look,
John

EL.sample.xls

[HansV]

In D15:

=SUMPRODUCT(($B9:$B12="Full-Time")*(D9:D12>0))+SUMPRODUCT(($B9:$B12="FullPart-Time")*(D9:D12>0))/2

Fill right to J15.

[jstevens]

Hans,

Just a minor correction:
=SUMPRODUCT(($B9:$B12="Full-Time")*(D9:D12>0))+SUMPRODUCT(($B9:$B12="Part-Time")*(D9:D12>0))/2


Thanks,
John

[HansV]

Sorry about that, forgot to adjust the second part.

[edoc intelligence]

Thanks HansV and jstevens....that is exactly what I was looking for!