Ask Your Question
0

Find cells with specific month on a column of dates

asked 2015-01-06 17:22:31 +0100

Evangelos Bempelis gravatar image

updated 2015-01-06 17:22:58 +0100

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2015-01-06 18:32:07 +0100

karolus gravatar image

It sounds as you should use →Data→Datapilot|Pivottable....

http://wiki.services.openoffice.org/w...

anyway: SUMPRODUCT works also with nestet Functions:

Something like:

=SUMPRODUCT( MONTH(A1:A100)=1 ; B1:B100 )

should fit your needs.

Karolus

edit flag offensive delete link more

Comments

Yes, indeed MONTH(A1:A100) did the job. I had tried it before but apparently I must have made a syntactic error.

Evangelos Bempelis gravatar imageEvangelos Bempelis ( 2015-01-07 14:17:57 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-01-06 17:22:31 +0100

Seen: 742 times

Last updated: Jan 06 '15