How to nest a left function within a sumif function?

For example:

Left(a2,3)
within a sumif function

How to do that?

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?
>.
>

[QUOTE=Jason Morin;893313]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
[color=blue]

Thanks, mate, you are great!