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 !
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 !
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