Thread: Excel function sumif help
View Single Post
 
Old 09-04-2021, 01:34 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Try in B1:
Code:
=SUMIF(Sheet2!$A$1:$A$12,LEFT(A1,FIND(":",A1,4)-1) & "*",Sheet2!$B$1:$B$12)
but your:
Code:
=SUMIF(Sheet2!$A$1:$A$12,LEFT(A1,FIND("#",SUBSTITUTE(A1,":","#",2))-1) & "*",Sheet2!$B$1:$B$12)
would be more robust.
Reply With Quote