Hello,
I been trying to sum a few numbers, which need to be in a few dates.
“A” is the dates and B is the numbers.
=SUM.IFS(B:B;A:A;"<"&Q1;A:A;">"&Q2)
Q1 and Q2 is the dates it need to be within.
Cant this be done in libreoffice?
I tried at work and it seems to work in Excel.
Thanks in advance,
Niklas
The SUMIFS function does not have a dot in the middle in any language I have used. Are you sure that is correct?
You have provided limited information about existing data, but I would guess that you have the start of the date range in Q1 and the end in Q2, not the other way around. Try to swap the conditions.
=SUMIFS(B:B;A:A;">"&Q1;A:A;"<"&Q2)
If my guess is wrong, I have another one. Excel makes a greater effort to interpret text content as numbers than what Calc does. Could it be that your column B contains numbers stored as text?