At 17:19 24/08/2018 +0200, Hylton Conacher wrote:
Formula worked perfectly, ...
Good-oh!
... HATS off to you Brian.
Thanks, but hats off to the SUMPRODUCT() function really.
My final formula:
=SUMPRODUCT(INT($Data.$A$3:$A$30/100)=$A4,$Data.D$3:D$30) to display
it a sheet different to
Greetings Brian,
To assist I redo my example data:
Date:Text :A :B
20180803:Cattle Baron:430.00:BLANK
20180805:Dischem :BLANK :1233.39
20180805:Checkers :BLANK:606.71
20180901:PNP :2000.00 :BLANK
20181001:WW : BLANK
At 08:59 24/08/2018 +0200, Hylton Conacher wrote:
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
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