[libreoffice-users] Add column values according to part of date value

Using LibreOffice Calc 6.0.6.2 on macOS High Sierra.

I have data in 4 columns titled Date:Text:A:B

A typical row example is: 20180822:PNP:blank:500.00 OR 
20180822:PNP:500.00:blank

A row will only have a value in column A or B, never both on the same 
row. There may be multiple rows with the same date but different Text 
and A or B value.

Example Data:

20180803:Cattle Baron:430.00:
20180805:Dischem::1233.39
20180805:Checkers::606.71
20180901:PNP:2000.00:
20181001:WW::150.00

1) How to SUM the values in column B for September i.e. 201809

I have tried vlookup coupled with IF and RANDBETWEEN, SUMIF. I have 
Googled myself silly looking for a way to SUM multiple values that meet 
a criteria i.e. 201808 or 201809. Vlookup and Hlookup have also not 
assisted as whilst they can return a single value, the addition of 
multiple values is an issue.

My thinking goes " SUM those values in the array a1:d5 that have the 
first column beginning with "201808" Putting that into a formula is 
what's getting me.

Pointers and solutions GREATLY appreciated.

Hylton

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy