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

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: 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