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"
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
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>