Wildcard with sumif
many thanks!
"Roger Govier" wrote:
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.
|