A1:A10 is the range of cells that contain your line items.
B1:B10 is the range to sum.

Maybe you need to post a more descriptive explanation.

Biff

"Amber" wrote in message
...
What do A and B Stand for?

"T. Valko" wrote:

Maybe something like this:

=SUMPRODUCT(--(LEFT(A1:A10,3)<"600"),B1:B10)

Biff

"Amber" wrote in message
...
What I am trying to do is do a sumif statement but there are some of
the
the
line items that I want to not be added. I need to try to figure out how
to
say that in an expression.... Any help you could give would be great.

Thanks Amber

" wrote:

On May 25, 10:59 am, Amber wrote:
How can I express the following within a function?

begins with
contains
ends with

I think you are looking for the LEFT, FIND, and RIGHT functions. Not
sure exactly how you want to use these but here's some examples:

Does the cell A1 begin with "Bob"?
=LEFT(A1,3)="Bob"

Does the cell A1 contain "Bob"?
=FIND("Bob",A1)0

Does the cell A1 end with "Bob"?
=RIGHT(A1,3)="Bob"


If you want to refer to another cell, say B1, then it's:
=LEFT(A1,LEN(B1))=B1
=FIND(B1,A1)0
=RIGHT(A1,LEN(B1))=B1


cheers,
..o.