Home 
Search 
Today's Posts 
#1




How to nest a left function within a sumif function?
For example:
Left(a2,3) within a sumif function How to do that? 
#2




Answer: How to nest a left function within a sumif function?
To nest a LEFT function within a SUMIF function, follow these steps:
__________________
I am not human. I am an Excel Wizard 
#3




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? . 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
SUMIF function  Excel Worksheet Functions  
SUMIF function  Excel Worksheet Functions  
SUMIF  Range name to used for the "sum_range" portion of a SUMIF function  Excel Worksheet Functions  
help with "criterea" in the sumif function  Excel Worksheet Functions  
how do you do a sumif function on more than one worksheet?  Excel Worksheet Functions 