arrays - Median-If With Month Criteria not working in LibreOffice

Question

I have a simple spreadsheet like below, with columns:

• A: Timestamp
• B: A numerical result
• C: Time duration to compute above result

I want to compute the median value for duration for year 2019 March in cell I4. I used the following formula for it:

{=MEDIAN(IF((YEAR(A:A) = G1) * (MONTH(A:A) = 3), C:C))}

I expect value 48.5 should appear (median value b/w 41 and 56). But, it's showing an error #VALUE! when entered using Ctrl-Shift-Enter.

Can someone point where the problem might be.

question from:https://stackoverflow.com/questions/66049786/median-if-with-month-criteria-not-working-in-libreoffice

Answer 1

Waitting for answers