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?
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)))