Hi

One way
=SUMPRODUCT(--(LEFT(A1:A307)="1"),F1:F307)

--
Regards

Roger Govier


"fractallinda" wrote in message
...
I'm trying to get the sum of a list of numbers that start with a
certain
number (in this example 1). I can't seem to make any wildcard work.
My
numbers all have 5 digits so I've tried 1* and 1????.
=SUMIF(A1:A307,"1*",F1:F307)
=SUMIF(A1:A307,"1????",F1:F307)
don't work. Will someone please tell me what I'm doing incorrectly?
Thanks
in advance.