How to nest a left function within a sumif function?

[Guest]

For example:

Left(a2,3)
within a sumif function

How to do that?

 

[Jason Morin]

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