The following formula is enclosed in 'sqiggly' brackets by using CtrlShiftEnter keys together :-

[bfn]=SUM(IF(AL4:AL33="d*",AJ4:AJ33)) [/bfn] (I can't remember the correct terminology for the function, I'm afraid)

Basically it's looking at a column of cells in range AL4:AL33 for the letter 'd,' then adding numbers found in column AJ4:AJ33 where each occurrence of the letter is found, and placing the results int he containing cell. I want the same to happen whether it's a 'd' or any word beginning with 'd'.

Hope this is followable - I'm sure it must be an easy one, but my knowledge doesn't extend that far, I'm afraid! I tried using ..."d*", or ..."d****", but whilst the formula is accepted no results are placed in the cell containing it.

I'm using Excel 2003.