Require possible formula to pick some data from cells and sum together

[reecechown]

Hi guys,

This is my first post on here so go easy...

I'm looking for a way to pick out only some information from a cell in a range of cells, and to add it all together. I'm not sure if this can be done in a single formula or if this is possible.

An example of the data in question is below, (some text has been changed to 'TEXT' for sensitive information):

20:38:14 TEST(*) TAKEN
20:38:16 CASH DISP/PRESENTED: 2:2,4
TEST
TEST SITE
TEST
TEST CD0000
Date Time Trans.no.
11/04/14 20:40 000000
TEST ***************0000
Pas 000
TEST SITE:
EUR 50.00
MAESTRO 0000000000000
Bedankt voor uw bezoek
20:38:25 <- TRANSACTION END
20:51:54 -> TRANSACTION START
20:51:54 TEST 2 DATA: 00000000000000********
20:52:00 TEST ENTERED
20:52:04 TEST REQUEST AAC C A
20:52:05 TEST REPLY NEXT 123 FUNCTION A040
20:52:05 TVTEST: 0000000000, TEST: 0000
20:52:05 TEST HOST REQ: 00000000
20:52:07 TEST(000000000000********) TAKEN
20:52:10 CASH DISP/PRESENTED: 1:1,3;2:2,1


The data in red is what I'm focusing on.

Each row of data is in a single cell. From the highlighted example '1:1,3;2:2,1' I need to add up all numbers after the commas, but separately for '1:1,??' and '2:2,??'

For example, the result from this test data above should give me two numbers;

1:1 = 3
2:2 = 5

The above example is just a small snippet of data, the full data for each would contain around 80-200 rows which contact '1:1,??'.

I hope this makes some kind of sense, let me know if you need anything clarifying.

Would REALLY appreciate any help anyone can give on this!

Thanks!
Reece

[hifliers]

Welcome Reece!!

please attach sample file (with out sensitive information ).

[reecechown]

Eventually found out how to attach it! Haha

Hopefully you can access it ok.

Thanks
Reece