=SOMME.SI.ENS(

%3CLINGO-SUB%20id%3D%22lingo-sub-3088442%22%20slang%3D%22en-US%22%3E%3DSOMME.SI.ENS(%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3088442%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20so%20you%20know.%3CBR%20%2F%3EI%20had%20a%20stroke%209%20years%20ago%2C%20I%20am%20aphasic%20(I%20speak%20badly)%20and%20I%20am%20hemiplegic.%3C%2FP%3E%3CP%3EIn%20expenses%202022%2C%20I%20am%20trying%20to%20do%20this%3A%3C%2FP%3E%3CP%3E-%20sum%20of%20the%20amount%20month%20by%20month%3B%3CBR%20%2F%3E-%20current%20account%20-%20'%207504%20'%2C%20household%20-%20'%204380%20'%2C%20current%20account%20-%20'%209888%20'.%3CBR%20%2F%3E-%20element%20metro%2C%20butcher%2C%20restaurant%2C%20...%3C%2FP%3E%3CP%3E%22We%20have%20encountered%201%20error%20in%20this%20formula...%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ECan%20you%20please%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture%20d%E2%80%99e%CC%81cran%202022-01-14%20a%CC%80%2008.51.55.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343632i5ADD786FD3C599D3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Capture%20d%E2%80%99e%CC%81cran%202022-01-14%20a%CC%80%2008.51.55.png%22%20alt%3D%22Capture%20d%E2%80%99e%CC%81cran%202022-01-14%20a%CC%80%2008.51.55.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3088442%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3088519%22%20slang%3D%22en-US%22%3ERe%3A%20%3DSOMME.SI.ENS(%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3088519%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1291320%22%20target%3D%22_blank%22%3E%40Jean-Marc_Aloy%3C%2FA%3E%26nbsp%3BThe%20formula%20you%20are%20using%20is%20difficult%20to%20read%20from%20the%20screenshot%2C%20but%20I%20believe%20you%20are%20applying%20an%20incorrect%20syntax%20for%20the%20SUMIFS%20function.%20As%20a%20simple%20example%2C%20this%20formula%20(in%20English%20notation)%20will%20work%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DSUMIFS(E3%3AE6%2CD3%3AD6%2C%22%26lt%3B%3D%22%26amp%3BDATE(2022%2C1%2C10))%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20this%20one%20(what%20you%20seem%20to%20have%20used)%20will%20not%20and%20will%20produce%20the%20error%20message%20you%20encountered%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DSUMIFS(E3%3AE6%2CD3%3AD6%2C%26lt%3B%3D10%2F01%2F2022)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELook%20into%20the%20help%20pages%20for%20the%20SOMME.SI.ENS%20function.%20It%20should%20all%20be%20explained%20there.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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?

 

Capture d’écran 2022-01-14 à 08.51.55.png

3 Replies

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

@Riny_van_Eekelen 

I am on a "MAC"

 

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