Hi
use something like
=SUMPRODUCT(--(LEFT(A1:A100)="1"),B1:B100)
Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Regards
Frank Kabel
Frankfurt, Germany
"Spunky" schrieb im Newsbeitrag
...
I want to sum the "qty" field in a database based on the "job
number". I
only want job numbers beginning with 1,2,3 or 4. Below is a list of
assorted
job number/alpha I might use.
Job number
103811
310225
350875-6
350875-7
350875-8
350875-8
370245-1
SKU#58214
Another formula I need is to sum "shipping lbs" in a database based
on the
product name. I only want products beginning with "c". Below is a
list of
assorted products I might use.
Product
Curriculum
Curriculum
Curriculum
VBS FLYER RETAIL
VBS FLYER WHOLESALE
VBS FLYER DENOMS
JUST ADD KIDS - RETAIL
PICK UP N DO SAMPLER
Curriculum
Curriculum
PRESCHOOLER'S BIBLE