Sum based on starting no. of codes

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

#12

03-25-2024, 06:58 AM

p45cal

Windows 10 Sum based on starting no. of codes

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

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)

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.