Help with SUMIFS formula - one condition only matching a part of the text in a cell...

[willow1985]

Hello,

I need some help with the below SUMIFS formula:

=SUMIFS(Table_Query_from_INCjobboss322[Order_Qty],Table_Query_from_INCjobboss322[Column1],[@SO],Table_Query_from_INCjobboss322[Material],[Part No])

The last section of the formula: Table_Query_from_INCjobboss322[Material],[Part No]

dictates if the Part number matches the number in the material column, unfortunately all part numbers in that column start with a"DH "

Is there anyway to incorporate maybe a LEFT formula to only match the contents of the cell 3 characters from the left?

Thank you to anyone who can help

 

[CA_Punit]

Just add "DH "&Criteria

 

[Fluff]

How about
=SUMIFS(Table_Query_from_INCjobboss322[Order_Qty],Table_Query_from_INCjobboss322[Column1],[@SO],Table_Query_from_INCjobboss322[Material],"*"&[Part No])

 

[willow1985]

Just add "DH "&Criteria

I get the below error when I write the formula this way:
=SUMIFS(Table_Query_from_INCjobboss322[Order_Qty],Table_Query_from_INCjobboss322[Column1],[@SO],"DH "&Table_Query_from_INCjobboss322[Material],[Part No])

 

[willow1985]

How about
=SUMIFS(Table_Query_from_INCjobboss322[Order_Qty],Table_Query_from_INCjobboss322[Column1],[@SO],Table_Query_from_INCjobboss322[Material],"*"&[Part No])

If I use "*" would that not grab that combination of characters for the part number if they exist in that cell? Because I may have situations where the part number can contain those characters and more, example:

DH XH5782
DH ATXH5782
DH WQ5XH5782

That's why I was hoping to single out the "DH " as that is always consistent...

 

[Fluff]

In that case replace the "*" with "DH "

 

[willow1985]

In that case replace the "*" with "DH "

Perfect! Thank you very much!

 

[Fluff]

Glad we could help & thanks for the feedback.