I have 2 columns of data. Dates and currency.
I need a formula that will look for a specific month and year in the date range and then sum up corresponding currency values.
The issue i have is that the date is not plain text, it comes from another formula. The same goes for currency on one of my sheets. I have a few sheets for apply this to.
If I replace the date as actual date text I can make this work with SUMIF but when the date comes from another formula my end result is always $0.00
How to do I specify a range of dates and have it pass the date values instead of the formula that generated those dates?
I attached an example of what I want it to look like.
I'd like each formula to reference the year 2014 in the corner and the month JAN.... above.
The purpose of my report is to go through a list of all the support contracts we have and add up the ammounts for each month of the year.