Get values from date ranges in table

[aislinnlc]

Hi there, I am trying to look up from a table dates within a range to then calculate the values into a cell on a different sheet. For example, I have an excel sheet which has 1500 entries, these entries are between the 28 March 2012 to current and have a costs associated to those dates. I can filter to find the cost and manually input the total figure into the next sheet, but wondered if there was a formula to get costs automatically into the cell for say April 2019 May 2019 and so on? Sorry if that sound sounds confusing! Any help would be great

 

[Joe4]

Welcome to the Board!

Are you saying that you are tyring to get the total monthly costs?
If so, see here: https://www.extendoffice.com/documents/excel/3459-excel-sum-by-month-and-year.html

 

[aislinnlc]

Brill thanks! it worked!

 

[Joe4]

You are welcome.