Thread: [Solved] Sum based on starting no. of codes
View Single Post
 
Old 03-25-2024, 06:58 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 872
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:
Code:
=SUMPRODUCT(($B$4:$B$47880=$E$3)*(((LEFT($A$4:$A$47880)="4")+(LEFT($A$4:$A$47880)="5"))>0)*$C$4:$C$47880)
Reply With Quote