Date range getting totals

Question

I have an Excel Spreadsheet with over 20 tabs one for each supplier where I record the date of an invoice, details about it and then the Invoice amount.

There is a SUMMARY sheet at the front where I show the Invoices Amount and Outstanding amount.

I would like to be able to get the total amount for each month automatically with a formula.

I  have been trying the following formula for Invoices Total:

=SUMIFS('A2 Tyres'!$F3:$F200,'A2 Tyres'!$A$3:$A$200,">=O$1",'A2 Tyres'!$A$3:$A$200,("<=Q$1-1"))

And

=SUMIFS('A2 Tyres'!$M3:$M200,'A2 Tyres'!$A$3:$A$200,">=O$1",'A2 Tyres'!$A$3:$A$200,("<=P$1-1"))

For the Total Amount Outstanding for each month.

Answer 1

Hi BobSpence48!

Please try the formula:

=SUMIFS('A2 Tyres'!$F3:$F200,'A2 Tyres'!$A$3:$A$200,">="&O$1,'A2 Tyres'!$A$3:$A$200,"<="&EOMONTH(Q$1,0))

AND

=SUMIFS('A2 Tyres'!$M3:$M200,'A2 Tyres'!$A$3:$A$200,">="&O$1,'A2 Tyres'!$A$3:$A$200,"<="&EOMONTH(P$1,-1))

Kindly let me know, if you require additional assistance, I will be glad to help further.

Best Regards, Shakiru