How can we help?

New post
0

Sum of current month

Avatar
Quentin Verhaeghe
None
Follow

Hello, 

I would like to get the sum of cells A:A who have date range the current month in column B:B 

i tried sumif(DATE_STARTOF(DATE(#Date Mois,"yyyy-MM"),"3"),#Marge;) but it doesn't work

Thanks for your help ! 

Date Votes

1 comment

  • 0
    Avatar
    Pratyusa Ray

    Hi Quentin,

    Thanks for the post.

    Instead of Date_Start_Of function in your formula you can use Date_IN function

    The formula would look something like this

    SUMIf(DATE_IN(DATE(@Date Mois,"MMM-yy"),month,0),@Marge) 

    Here A:A is marge and B:B is Date Mois.

    Hope this helps! If you have any further questions around this, let us know by logging a ticket with our support team at support@klipfolio.com . 

    Best,

    Pratyusa Ray

Please sign in to leave a comment.