View Single Post
  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

Unless you're talking about the criteria portion of
SUMIF, you can't. But you can do this:

=SUMPRODUCT((LEFT(A2:A100,3)="jas")*B2:B100)

Which calculates as:

"Sum everything in col. B where the first 3 characters of
the values in col. A = "jas".

HTH
Jason
Atlanta, GA

-----Original Message-----
For example:

Left(a2,3)
within a sumif function

How to do that?
.