Hello,
I am hoping to use a formula instead of a pivot table to get a summary result based on date in one column and summing the quantity from another column. The attached spreadsheet shows an example. I have widget quantities in column J and there are dates in column K. Projects will be added for the next few years, so there will be additional dates down the road.
Bookmarks