Macro to sum values based on looking up a value within a date range

**Jace15** · 05-19-2014, 04:28 AM

Hi All,

I have a VBA or function query.

I have a spread sheet with the following.

Column A contains asset names
Column H to JZ contains cash outflows for each asset
Row 17 contains a Month&Date value (ie. July2013)

What i want to do is, from another sheet, is to calculate the sum of all cash outflows for the asset (determined by a cell value) for a date range entered.
In other words, if i say 1/7/2012 to 30/6/2014, it will look the asset up, and sum the value of cashflows, in colums that fall between those dates for that asset.

Hope this has given enough information to provide feedback.

Thanks.