Hi everyone, I'm trying to prepare my data for a pivot table. The context / purpose is that I'm trying to determine the rate of how much hard drive space my company purchases over time for each of our datacenters. My spreadsheet has 3 columns:
Column1 - Quote Dates: has random dates from 2010 to present
Column2 - Datacenter: has any of 5 or 6 datacenter names where the hard drive space was ordered for
Column3 - Terabytes: has the number of Terabytes purchased on that date.
I have added a new column named "Dates" which has all first days of the month since 1/1/2010. I want to have a SUM of purchased storage for each month so that when I add my pivot table/chart, I have all months present for data points.
I have tried a lot of things and it seems like text or Month(cellrange) do not work well with IF, AND, IF(AND(, or SUMIF/SUMIFS. Would anyone ever take a look at my spreadsheet (B2 contains my latest formula attempt) and let me know if it's possible to do what I want?
Thanks in advance.