Sumifs

[Joe Carrigan]

In column A I have all the days of the financial year, in column M I have my daily takings for each day.
I would like to be able to have a total for each month, what’s the easiest way please?

 

[Fluff]

How about

Excel 2013/2016
	O	P
1	01/01/2019	01/02/2019
2	496	99
TB

Cell Formulas
Range	Formula
O2	=SUMPRODUCT((MONTH($A$2:$A$35)=MONTH(O1))*($M$2:$M$35))

 

[Scott T]

Try
where P3 has the start date and Q3 has the end date
adjust ranges as need

=SUMIFS(M1:M146,A1:A146,">="&P3,A1:A146,"<="&Q3)

 

[Joe Carrigan]

Sorry, gives a value error.
I'm after a monthly cash total for each month

 

[Joe Carrigan]

Works a treat thanks

 

[Fluff]

Is col M formulae? If so do any of those formulae return #VALUE!
Also do you have any text vales in col M?

 

[dheeraj27]

This can easily done with pivot table.

create pivot table and then go to option inn ribbon and select group selection

 

[Twollaston]

In column A I have all the days of the financial year, in column M I have my daily takings for each day.
I would like to be able to have a total for each month, what’s the easiest way please?

This sounds like a good spot for a pivot table. You can grab all of your data and then insert a pivot table. Put the date into the row labels and daily takes in the values. Then you can group your dates however you want by selecting a date and right clicking it, select "Group", and then select month (or month and year if you want to distinquish between months in different years)

 

[Joe Carrigan]

THanks very much for all your answers guys, Scott T's formula works a treat. I did however forget to mention i also have criteria in column E, so;
In column A I have all the days of the financial year, in column M I have my daily takings for each day.
I would like to be able to have a total for each month, but only if column E equals "S". what’s the easiest way please?

 

[Fluff]

How about
=SUMIFS(M1:M146,A1:A146,">="&P3,A1:A146,"<="&Q3,E1:E146,"S")