I would like to the sum of one column based on a specific date range in another column.
e.g Need to total costs for June 2018. I am using the following formula
=SUMIFS(Cost3:Cost29,[End Date]3:[End Date]29,”>=01/06/2018″,[End Date]3:[End Date]29,”<=30/06/2017″)
However it is coming back with an error #UNPARSEABLE.