# Libre office conditional sum no more works for newer versions (italian)

Hi all, I'm using for a long time a spreadsheet in LibreOffice Calc with formulas of this type:

```
{=SOMMA( (H27:H3001=1)*(MESE(A27:A3001)=N20)*J27:J3001 )}
```

to perform a conditional sum over a range of cells, but from version 5 I get the '#value!' error, so I can't use newer versions of the product. Is there a way to make compatible the formula with newer versions? (The formula works on Excel too).

Thanks

This looks a bit as if the array-evaluation is broken for your formula. (It does not occur for me.)

I would suggest you first try

`=SUMPRODUCT(H27:H3001=1;MONTH(A27:A3001)=N20;J27:J3001)`

which should implicitly force array-evaluation.Please report again.

(There is an option under > 'Tools' > 'Options' > 'LibreOffice Calc' > 'Formula' to use English function names independent of the chosen UI language. This setting obviously has advantages if help from an international forum is needed.)