Selecting specific text and suming the results.

[mozahra]

Dear All,

Thanks in advance for your time to help me with my inquiry.

I have some expenses data where I want to select common or close text from a list and sum the amount spent for a specific month "Mar". Then I will work on creating a dashboard out of it.


Example of output required.

ENOC SITES : 140 ARE. [ Data below is having different Site numbers, but I want to group them all together]
SHARJAH CO-OP : 260 ARE.

9-Mar-17	ENOC SITE 1032 DUBAI UAE	ARE	95.01
8-Mar-17	SHARJAH CO-OP, HALWAN SHJ ARE	ARE	16.95
6-Mar-17	AL ZAJIL FAIRS MANAGEM SHARJAH ARE	ARE	100.00
6-Mar-17	AL ZAJIL FAIRS MANAGEM SHARJAH ARE	ARE	90.00
6-Mar-17	ADNOC AL ASRAR ABU DHABI ARE	ARE	114.00
6-Mar-17	SHARJAH CO-OP, HALWAN SHJ ARE	ARE	73.55
6-Mar-17	AL SHAAB VILLAGE-AL ZA SHARJAH UAE	ARE	50.00
6-Mar-17	AL SHAAB VILLAGE-AL ZA SHARJAH UAE	ARE	40.00
6-Mar-17	AL SHAAB VILLAGE-AL ZA SHARJAH UAE	ARE	100.00
6-Mar-17	AL SHAAB VILLAGE-AL ZA SHARJAH UAE	ARE	55.00
5-Mar-17	AL MANAMA H/MARKET-BR DUBAI ARE	ARE	63.90
4-Mar-17	ENOC SITE 1036 DUBAI UAE	ARE	112.01
3-Mar-17	SHARJAH CO-OP, HALWAN SHJ ARE	ARE	100.80
2-Mar-17	GIFTS MARKETS GEN.TRAD SHARJAH ARE	ARE	49.50
1-Mar-17	SHARJAH CO-OP, HALWAN SHJ ARE	ARE	142.40

<tbody>
</tbody>

Thanks in advance for your support and efforts.

 

[mozahra]

Thanks 63Falcondude you got it right and Thanks for everyone for your support

 

[63falcondude]

You're welcome.