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 data
You might prefer to enter your dates as real dates, which could be
formatted the way you have them using "YYYYMMDD" as the format
string. Then you could extract year and month using the YEAR() and
MONTH() functions:
=SUMPRODUCT(YEAR(A3:A30)=2018;MONTH(A3:A30)=9;D3:D30)
Brian Barker
--
To unsubscribe e-mail to: [email protected]
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
