Sum based on starting no. of codes

		Microsoft Office Forums > Microsoft Excel > Excel
Sum based on starting no. of codes

#13

03-25-2024, 08:51 AM

xor

Windows 11 Sum based on starting no. of codes

Office 2021

Expert

Join Date: Oct 2015

Posts: 1,102

Or

=SUMPRODUCT(($B$4:$B$47880=$E$3)*(LEFT($A$4:$A$478 80)={"4""5"})*$C$4:$C$47880)

where {"4""5"} for you should be {"4","5}

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to hide/delete slides based on keyword in a separate text file based on AND\|OR condition?	rupd911	PowerPoint	0	02-22-2021 08:22 AM
QR codes in Word	lreinhard7	Word	1	12-19-2019 06:46 AM
Enter a city based on a short list of zip codes	jcgwilym	Excel	1	04-19-2017 10:53 AM
Need help with Field Codes	Cosmo	Mail Merge	25	07-30-2015 01:25 PM
Is it possible to merge the two VBA codes into just one	sam2149	Excel Programming	0	02-26-2014 05:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:22 AM.