Forum Discussion
=SOMME.SI.ENS(
Just so you know. I had a stroke 9 years ago, I am aphasic (I speak badly) and I am hemiplegic. In expenses 2022, I am trying to do this: - sum of the amount month by month; - current account - '...
Jean-Marc_Aloy The formula you are using is difficult to read from the screenshot, but I believe you are applying an incorrect syntax for the SUMIFS function. As a simple example, this formula (in English notation) will work:
=SUMIFS(E3:E6,D3:D6,"<="&DATE(2022,1,10))
But this one (what you seem to have used) will not and will produce the error message you encountered:
=SUMIFS(E3:E6,D3:D6,<=10/01/2022)
Look into the help pages for the SOMME.SI.ENS function. It should all be explained there.
Jean-Marc_Aloy That doesn't matter. The rules for SUMIFS are the same on Mac and PC.