# SUMIFS with multiple criteria and partial text

#### Lizzi

##### Board Regular
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

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

#### svendiamond

##### Well-known Member
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

##### MrExcel MVP, Moderator
=sum(sumifs(L:L,A:A,{"ABC","DEF"},F:F,"RN*"))

#### Lizzi

##### Board Regular
=sum(sumifs(L:L,A:A,{"ABC","DEF"},F:F,"RN*"))

Fantastic thank you

#### Fluff

##### MrExcel MVP, Moderator
Glad we could help & thanks for the feedback

Replies
3
Views
162
Replies
6
Views
138
Replies
2
Views
51
Replies
4
Views
364
Replies
7
Views
727