Excel function sumif help

		Microsoft Office Forums > Microsoft Excel > Excel
Excel function sumif help

09-04-2021, 01:34 PM

p45cal

Windows 10 Excel function sumif help

Office 2019

Expert

Join Date: Apr 2014

Posts: 962

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel function help	ganesang	Excel Programming	4	09-20-2021 01:48 AM
Data connection problem excel/sharepoint using an SUMIF array	mwestra74	Excel Programming	10	11-28-2017 06:26 PM
Ms Excel 2016 IF function	IFnoob	Excel	1	08-13-2016 11:34 PM
Excel function issue	Nobody	Excel	1	06-30-2014 12:26 PM
Excel Function	co-lay	Excel	3	02-13-2012 03:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:21 PM.