Add up each month for each country

[leovilla]

Good afternoon everyone
I need to add up each month for each country, I started trying with SomaSes, but it showed some errors. Can you help me?

Thank you

[protonLeah]

deleted......

[wk9128]

Worksheet or Tab name : Planilha1

Cell B4 formula , Drag down and across

Please Login or Register  to view this content.

[Eeza Goodun]

Alternative solution:

1. Make row 3 all dates (first of each month) and format the cells to just display the month (Custom>Type mmmm)
2. in cell B4 (copy across and down) =SUMIFS(Export!$E$4:$E$999, Export!$B$4:$B$999,">="&B$3,Export!$B$4:$B$999,"<"&EDATE(B$3,1), Export!$D$4:$D$999,$A4)
3. Format your money cells.

[leovilla]

Good morning, thank you very much for your help, everything went well

[wk9128]

leovilla You're Welcome. Glad to help . Thank You for the feedback.

you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower
left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.