I have a column with dates, say A1:A10, and I want to check which dates are January, e.g. MONTH(A1) = 1. However, I don’t know how to use MONTH function on an array, if such thing is possible. I need to produce an array of TRUE/FALSE, so that I can later use it with SUMPRODUCT.
I am using LibreCalc 4.2.7.2 on Ubuntu 14.04.
It sounds as you should use →Data→Datapilot|Pivottable…
http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot
anyway: SUMPRODUCT works also with nestet Functions:
Something like:
=SUMPRODUCT( MONTH(A1:A100)=1 ; B1:B100 )
should fit your needs.
Karolus
Yes, indeed MONTH(A1:A100) did the job. I had tried it before but apparently I must have made a syntactic error.