SUM a range if the DATE is in the same MONTH and YEAR, AND is from the same acount

Hello,

I have a table with columns 'Date', 'Account', 'Sales'.

I need a formula that will give me the given sales for a certain month, for a certain account.

Ive tried various SUMIFS '=SUMIF(Table1[Billing Month],(MONTH(A191)&YEAR(A191) = MONTH(Table1[Billing Month])&YEAR(Table1[Billing Month])),Table1[Net Invoice Value])'

Ive looked at Arrays =SUM(IF(MONTH($A$2:$A$6)=1,$B$2:$B$6,0))

And I cant figure it out!!!!

Any help would be much appreciated

Thanks

Managed to figure it out using arrays and if statements!!

{=SUM(IF(Billing[Contract]=Template!A1,IF(MONTH(Billing[Billing Month])&YEAR(Billing[Billing Month])=MONTH(Template!A191)&YEAR(Template!A191),Billing[Net Invoice Value])))}

hope that helps someone in the future!