Try this:

=SUMPRODUCT(--(A1:A5="Printed"),--(LEFT(B1:B5,2)="gt"))

Biff

"Jorgen Jansson" wrote in message
...
I've got a list:

Job Status Job Name
Printed gt0307poster final.pdf
Printed gt0407poster_final.pdf
Error cs0207expert_03.pdf
Canceled gt0507poster final.pdf

I want to count number of items that has Job status "Printed" and starts
with the letters "gt". I've tried with a sumproduct formula:

=SUMPRODUCT((A1:A5="Printed")*(B1:B5="gt*"))

But it doesn't seem to work with the wildcard character "*". Any way
around
this?

Thanks in advance