SUMIFS with multiple criteria and partial text

[Lizzi]

Hi

looking for some help please, i'm trying to do a sumifs with multiple criteria and a partial text but i seen to be having issues

column A will contain "ABC and DEF" column L is the revenue amount and column F contains text "RNXXXX" (amongst other text) but i only want it to pick up the rev amount that corresponds to "ABC & DEF and "RN"

does that make sense?
column A Column F Column L Result would = 2,500
ABC RNXXX 1,000
DEF RNXXX 1,500
ABC POXXX 2,000

Many thanks with any help you can provide

 

[svendiamond]

There is probably a fancier way using SUMPRODUCT but this should work for now:

=SUMIFS(L:L,A:A,"ABC",F:F,"RN*")+SUMIFS(L:L,A:A,"DEF",F:F,"RN*")

 

[Fluff]

How about
=sum(sumifs(L:L,A:A,{"ABC","DEF"},F:F,"RN*"))

 

[Lizzi]

How about
=sum(sumifs(L:L,A:A,{"ABC","DEF"},F:F,"RN*"))

Fantastic thank you

 

[Fluff]

Glad we could help & thanks for the feedback