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+unsubscr...@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