Variable start date pivot table or anothe roption?

[guamlenahans]

Hi,

Have a data set with 6 columns and roughly 10000K rows. My columns are: Date/Initials/Commidity/Weight/Container Weight/Net Weight. I use this data to track how much recycling material is processed with 4 different types of commidities. However, while this is used for every entry, once my recycling container is full I have a line entered showing the bin was changed out. I'm trying to figure out how to have a running sum of net weight from when the bin was changed out. Each time the bin was changed, the counter would start at zero.

Thanks in advance.

Rob

 

[guamlenahans]

Nevermind, SUMIFS was the charm.