Home > Enterprise >  Google Sheets - Trying to create a SUM of earnings per MONTH & per YEAR
Google Sheets - Trying to create a SUM of earnings per MONTH & per YEAR

Time:01-19

I'm new to all excel google sheet and I was tasked to creat a sheet in which i have a tab/sheet called "Payments" where I record payments from jobs along with other info like date.
I want to create another tab called "Statistics" where I want to SUM all earnings per specific month that is seperate for each year.

I am currently trying to use =ArrayFormula(SUMIF(MONTH(Payments!E2:E500)&YEAR(Payments!F2:F500),"="&MONTH("April")&YEAR("2023"),Payments!H2:H500)), but not sure why this doesn't work out.

Can you please help?

Link to the enter image description here

CodePudding user response:

Here's something else you can try (in B2):

=ArrayFormula(LAMBDA(table,{table;BYCOL(table,LAMBDA(col,SUM(col)))})(SUMIF(Payments!E2:E&Payments!F2:F,A2:A13&B1:F1,Payments!H2:H)))
  • Related