Help with autofilling cells

[shutchinson]

Hi Guys,

Thought i'd finished my timesheet project, but it seems not, I am in need of your expert advice once more please.

If you see the attached file.

Column H cells 10-40 contain codes I want to be able to auto fill the following, any help appreciated.

Cell D43 i want to add the hours found in column G where the code in H starts with the single letter S

Cell D45 i want to add the hours found in column G where the code in H starts with the single letter I

Cell H42 i want to add the hours found in column G where the code in H starts with the TWO letters AL


Not sure if that makes sense ?



Regards

[Marcol]

Try this

In D43
=SUMPRODUCT(--(LEFT(H10:H40,1)="S"),G10:G40)

In D45
=SUMPRODUCT(--(LEFT(H10:H40,1)="I"),G10:G40)

In H42
=SUMPRODUCT(--(LEFT(H10:H40,1)="I"),G10:G40)

Hope this helps