IF THEN formula

[kkuhn]

In column A I have a series of alphanumeric numbers, half of them start with the letter "W". In column D, I have corresponding amounts. I need a formula that will give me a total amount of all those in column A that start with the letter "W".

Can anyone please help?

Many thanks
Kristina

[Cutter]

Try this:
=SUMPRODUCT(--(LEFT(A1:A5000,1)="W")*(D1:D5000))

Adjust the A1:A5000 and D1:D5000 to the range you are using

[kkuhn]

Thank you - that's brilliant!

Kristina