#1
|
|||
|
|||
Excel function sumif help
Hi Guys I have the workbook which need to populate sumifs from sheet 2 to sheet 1. I have used the function SUMIFS but some of the lookups only matches partially and cannot get values. Please find the attached sheet and help me thanks Ganesan. g |
#2
|
|||
|
|||
How about this?
Sorry! Wrong file! |
#3
|
|||
|
|||
I think it's a right one now!
|
#4
|
|||
|
|||
Thanks it works with support column!
|
#5
|
|||
|
|||
Sorry again that number 1127 may be come in any length like 987 etc
What will do in this case? |
#6
|
|||
|
|||
Quote:
In case some of such numbers must be grouped, and some not - I think you'll have to calculate all of it manually! |
#7
|
|||
|
|||
Hi thanks for the replay!!
I think the left function use to sort out my issue LEFT(D116,FIND("#",SUBSTITUTE(D116,":","#",2))-1) |
#8
|
||||
|
||||
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) |
#9
|
|||
|
|||
Thanks for reply!!
|
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 |