|
|
#8
09-04-2021, 01:34 PM
|
||||
|
||||
Try in B1:
Code:
=SUMIF(Sheet2!$A$1:$A$12,LEFT(A1,FIND(":",A1,4)-1) & "*",Sheet2!$B$1:$B$12)
Code:
=SUMIF(Sheet2!$A$1:$A$12,LEFT(A1,FIND("#",SUBSTITUTE(A1,":","#",2))-1) & "*",Sheet2!$B$1:$B$12)
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2019
Threaded Mode