Sum values based on certain criteria

[willwall]

Hello
I am trying to get the sum of cells containing certain text. For example, I would like to get the sum of the cells that contain the following text "WILLYS", "GROSS", "SKANSEN"

Bokf.dat	Trans.dat	Text	Amount
2018-05-07	2018-05-06	WILLYS KUNGSGATAN UPPS UPPSALA	-2175,49
2018-05-07	2018-05-06	VERO MAT CAFE UPPSALA	-296,00
2018-05-07	2018-05-06	CITY GROSS UPPSALA UPPSALA	-39,00
2018-05-07	2018-05-06	LINDEX/363 UPPSALA	-398,00
2018-05-07	2018-05-06	SKOHUSET UPPSALA	-398,00
2018-05-08	2018-05-08	ensin	-1000,00
2018-05-10	2018-05-09	APOTEKET BOLANDERNA UPPSALA	-246,40
2018-05-11	2018-05-11	Test	2000,00
2018-05-11	2018-05-10	PANDURO HOBBY UPPSALA	-299,84
2018-05-11	2018-05-10	BRLeksaker F2273 Uppsala S	-123,70
2018-05-11	2018-05-10	KONDITORI FAGELSANGEN GRA UPPS	-120,00
2018-05-11	2018-05-09	STORA COOP BOLANDERNA UPPSALA	-304,88
2018-05-12	2018-05-11	DJURGARDSBRON SJOCAFE STOCKHOL	-80,00
2018-05-12	2018-05-11	NYBRO GRILLEN STOCKHOLM	-359,00
2018-05-12	2018-05-11	SKANSEN STOCKHOLM	-310,00
2018-05-13	2018-05-12	KD APOTEK UPPSALA	-416,50
2018-05-14	2018-05-13	ICA KRYSSET ALMUNGE ALMUNGE	-216,68
2018-05-15	2018-05-14	WILLYS KUNGSGATAN UPPS UPPSALA	-1191,83
2018-05-15	2018-05-14	QPARK ATOS STOCKHOLM	-72,00
2018-05-16	2018-05-15	FJALLNORA FRILUFTSGARD UPPSALA	-62,50

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[tyija1995]

You could use SUMIF with a wild card:

=SUMIF($C$2:$C$21,"*WILLYS*",$D$2:$D$21)

Assuming C2:C21 contains the text and D2:D21 is the amount.

This returns -3367.32 in this example.

EDIT: If you want it more dynamic then make some helper cells with the words "WILLYS", "GROSS" & "SKANSEN" in and reference them instead.

I.e. if cell G2 is "SKANSEN" then:
=SUMIF($C$2:$C$21,"*"&G2&"*",$D$2:$D$21)

 

[willwall]

Works perfect, thanks for your help

 

[willwall]

Hello again
Just one more question. This formula returns for example "skansen". =SUMIF($C$2:$C$21,"*"&G2&"*",$D$2:$D$21) (Skansen is in cell G2)
How do i write the formula to return "Gross" and skansen together, lets say "Gross" is in cell G3?

 

[tyija1995]

I'd probably just do an addition in that case:

=SUMIF($C$2:$C$21,"*"&G2&"*",$D$2:$D$21)+SUMIF($C$2:$C$21,"*"&G3&"*",$D$2:$D$21)

 

[willwall]

Works great, thanks