=SOMME.SI.ENS(

[Jean-Marc_Aloy]

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 - ' 7504 ', household - ' 4380 ', current account - ' 9888 '.
- element metro, butcher, restaurant, ...

"We have encountered 1 error in this formula...

Can you please help me?

 

[#2]

@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.

[#3]

@Riny_van_Eekelen 

I am on a "MAC"

[#4]

@Jean-Marc_Aloy That doesn't matter. The rules for SUMIFS are the same on Mac and PC.